Code to expand/collapse combo box drop-down list

  • Thread starter Thread starter Graham Walker
  • Start date Start date
G

Graham Walker

Does anyone know code to automatically expand a combo box list when the
control receives the focus and collapses it when the focus is lost?

Thanks
 
In the Enter event, or GotFocus event use:

Me.ComboBoxName.Dropdown

When you exit the combo box control the list will retract.
 
Thank you Arvin for your quick reply. I just used your code and it works
like a charm.

Thank you again.
 
Back
Top