ComboBox Toolbar

[Nader]

Hello,

I have a combobox on my excel toolbar which I have filled with data.

What I would like to do is everytime I start typing on that combobox it
automatically dropdown the list just like on http://finance.google.com when
u start typing the name of a company and u've got a list of name that
appears.

Thanks in advance.

Regards,

Nader

 

[Brian Withun]

Nader,

If you have a combo box on a worksheet and that combo box has both a
LinkedCell and a ListFillRange, then you can modify that combo box to
search for matching entries as you type by setting its MatchEntry to a
value of 1 (or the symbolic value of fmMatchEntryComplete)


MatchEntry Property

Returns or sets a value indicating how a ListBox or ComboBox searches
its list as the user types.


Regards,

Brian Herbert Withun

 

[Nader]

Hello Brian,

Thanks for the answer but my combox is on a commandbar (msoControlCombobox).

I just want to dropdown the list as soon as the user start typing in the
combobox instead of having to click on the arrow next to it.

thanks!