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
 
Back
Top