Combo Box Auto Dropdown

H

HornJM

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.
 
H

HornJM

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

Barry Gilbert

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

MyComboBox.DropDown

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

Barry
 
Top