ActiveX drop down keeps expanding

[STEEL010]

Dear all,

I want to have an solution for next thing.

I have activeX control drop down box and when I used it and it give results there is no problem. but when a select or edit an other cell and enter then the drop down menu expands???

See below my code, hopefully somebody can help.

Private Sub ComboBox1_Change()
ComboBox1.DropDown
If Range("B5").Value <> "" Then
Range("B6").Value = Evaluate("=VLookup(B5,SEARCH, 7, 0)")
Else
On Error Resume Next
Range("B6").ClearContents
End If
End Sub


Greetings,

Steel010

 

[Kyle123]

Use a forms control dropdown instead. You're better off not using ActiveX controls on worksheets at all. They're incredibly unstable have a look here https://www.google.co.uk/webhp?sour...espv=2&ie=UTF-8#q=resizing worksheet controls and by using them, you're asking for trouble.

Forms controls are much more reliable - they're in the same dropdown as the ActiveX ones, but are designed for use on worksheets - so you don't run into any stability issues, you can do most of the same things with them too and you can use them without using code.