View Single Post
  #1   Report Post  
DO
 
Posts: n/a
Default Getting combobox dropdowns to appear on a userform when tabbed to.

I have generated a userform with several comboboxes. A person using the form
tabs through the comboboxes and makes appropriate changes to the values. I
want the dropdown selection to appear when the combobox is tabbed to. I used
the Enter event for each combobox to execute the dropdown. However, when I
tab through the comboboxes without making any changes, the dropdown menus
only appear on every other combobox. If I make a change to a combobox and
tab to the next one, its dropdown menu will appear. I want the dropdown
menus to appear for all of the comboboxes when they are tabbed to regardless
of whether or not any changes to previous comboboxes are made.
Thanks,
DO