ComboBox in Toolbar with drop down list and filter function.

[ali84pk]

Dear Gurus,

I am trying to make combo box in toolbar and I got below codes for this purpose.

http://www.visiblevisual.com/index.p...d-toolbar.html

But now I need little more adjustment, like, when we click combo box, it should open drop down list and as we type, it should bring matching values in combo box.
Same like as we use in combo box of userform.
eg: ComboBox1.DropDown

(in example given in web link, it close the drop down list as we type, which i need to remain open till we don't press enter)


Thanks in advance.

[dominicb]

Good morning ali84pk

like, when we click combo box, it should open drop down list and as we type, it should bring matching values in combo box.

Not sure if I'm missing something here, but I've just copied the code in the link into a new workbook, and it works just fine - as in just how you want it to - autocomplete and all?

Was there something else?

HTH

DominicB

[ali84pk]

Dear Dominicb,

Thanks for your interest in helping me. Yes everything is fine in those codes, I just want, when i start typing, the dopdown list remains open and keep bringing matching items on top.

Thanks