Searchable Drop Down

[Rahulwork]

Hello Everyone,

I just made excel searchable drop down by using active x control (Combo Box) and it's working fine

But to select the drop down value i have to use Mouse , however i want to select the drop down value by arrow keys.

is it possible? Please help

 

[NoSparks]

Sorry, not interested in guessing how you tried.

 

[oldbrewer]

show us any code and formulas

 

[kamranyd]

Private Sub ComboBox1_GotFocus()    
ComboBox1.ListFillRange = "DropDownList1"
Me.ComboBox1.DropDown
End Sub

i want to use keyboard arrows key for up and down selection and enter, currently i can select with mouse only.
"It is a ActiveX combobox"

 

[oldbrewer]

you do not seem to be trying the code found in post #8

 

[kamranyd]

i tried my list show nothing than. so is there any codes for that. plz help