pulldown keeps pulling down?

[STEEL010]

Hi There,

I have an google pulldown menu that works fine, but when I select an other cell I keeps pulling down?
hereby my code, what am I doing wrong?

Private Sub ComboBox_Change()
ComboBox.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

 

[Joe4]

A "Google" pull-down menu?
Is this a "Google sheets" project or an Excel one?

 

[STEEL010]

Hi,

Its an Excel sheet. Its only that you can find your search in an google way

 

[Joe4]

Can you explain to us exactly how you created this "Google" drop-down?
Is it a Form control or ActiveX control?

 

[STEEL010]

Hi Joe4,

sorry for the late response, but its in fact an ActiveX control combo box. but in a way you do a search like you do in "google" nothing more then that. YouTube is full of it.
Have you ever heart like a problem I have?

 

[Joe4]

Unfortunately, I don't really use any ActiveX controls, other than the occasional calendar.

 

[STEEL010]

maybe somebody else can help?

thanks anyway Joe4