Open drop down on focus

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am using Office 2003 on Windows XP.

I would like to know how to have a combobox - the drop down portion - open
when the control receives focus.

Is this possible, if so can someone please post example VBA to do this?

Thanks much in advance.
 
quartz said:
I am using Office 2003 on Windows XP.

I would like to know how to have a combobox - the drop down portion - open
when the control receives focus.
Click to expand...

In the combo box's On Got Focus property put the following code:

Me!yourComboBoxName.dropdown

I think that will do the job.

Mike
 
Back
Top