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

 

[Rahulwork]

Please assist..

 

[oldbrewer]

show us the code so far please

 

[Rahulwork]

Code of the worksheet is:

Private Sub ComboBox1_Change()
ComboBox1.ListFillRange = "DropDownList"
Me.ComboBox1.DropDown
End Sub

 

[Rahulwork]

any solution??

 

[oldbrewer]

maybe google how to disable mouse in a macro (and re-enable it)

 

[Rahulwork]

There is nothing on google, regarding this

 

[NoSparks]

Googled "excel how to select sheet combo box with keyboard"
this was first result

https://www.pcreview.co.uk/threads/how-can-i-activate-a-combobox-by-keyboard-strokes.963199/

 

[oldbrewer]

that certainly seems to cover it - well done NoSparks !

 

[Rahulwork]

i tried that , but still not able to do it.