ComboBox on a Toolbar (msoControlComboBox)

**redan** · 08-14-2007, 10:51 AM

Hello dominicb,

Have u checked the Google Finance website .... As soon as u start typing inside the combobox I want the dropdown list to open and to give the user choices from the list.

Thanks for ur help.

**redan** · 08-14-2007, 10:55 AM

check out the print screen I've attached.

I want to do exactly the same thing ... that way the user do not have to click on the arrow next to the combobox. Instead, u just need to type in and u have a choice of matching item.

Nader

**dominicb** · 08-14-2007, 11:11 AM

Hi redan

AFAIK there is no way to actually force the box to dropdown, apart from clicking on the arrow, but when you start typing the auto-complete feature does kick in.

HTH

DominicB

**royUK** · 08-14-2007, 11:27 AM

Why are you using a Toolbar to do this? A combobox on a UserForm could be used instead.

**redan** · 08-14-2007, 11:38 AM

yes, as soon as I start type in the auto-complete feature does kick in.

I'm using the toolbar cuz it's a lot more easier and friendly for the user.

Also, i want this combobox to always be there and not to click on some button everytime I need the combobox.

I've got another question regarding msoControlComboBox, is is possbile to have many columns and title?

thanks everyone!

ComboBox on a Toolbar (msoControlComboBox)

LinkBack

Thread Tools

Rate This Thread

Display

Hybrid View

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions