Combo Box Auto Dropdown

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
Sorry...I posted this in the wrong forum. I've done this in Access...just
having trouble getting it to work in Excel.
 
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

Use up and down cursor keys in combo box 1
Combo Box gets focus but I can't enter data??? 13
Combo Box Dropdown 4
Using a Combo Box for Filtering a Continous Form 1
re run query using new combo box selection 2
COMBO BOX vs Uppercase 6
Code working in 2K3, but not 2K7 4
Run a Procedure automatically 3

Back
Top