Combo Box Auto Dropdown

G

Guest

How do I get a combo box to dropdown automatically as soon as it has the
focus? I want the form operator to click JUST the selection, rather than the
down arrow AND the selection.
 
G

Guest

Sorry...I posted this in the wrong forum. I've done this in Access...just
having trouble getting it to work in Excel.
 
G

Guest

In the combobox's GotFocus event, enter this code:

MyComboBox.DropDown

You'll need to substitute the actual name of your combobox.

Barry
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

re run query using new combo box selection 2
Use up and down cursor keys in combo box 1
Combo Box gets focus but I can't enter data??? 13
Combo Box List Dropdown 1
Using a Combo Box for Filtering a Continous Form 1
Combo Box Dropdown 4
Code working in 2K3, but not 2K7 4
Drop Down changes background color 5

Top