Combobox
 

Hi All
Is there a way for a UserForm ComboBox (set a list) - drop down to be
triggered from code?

Presently the dropdown arrow must be clicked by the user, I would like the
list to open automatically.

TIA

--

Regards,
Nigel

Combobox
 

Try the combobox Dropdown method.

--
Jim
"Nigel" wrote in message
...
| Hi All
| Is there a way for a UserForm ComboBox (set a list) - drop down to be
| triggered from code?
|
| Presently the dropdown arrow must be clicked by the user, I would like the
| list to open automatically.
|
| TIA
|
| --
|
| Regards,
| Nigel
|
|
|
|

Combobox
 

Thanks, works a treat. I was looking for a control property!

--

Regards,
Nigel




"Jim Rech" wrote in message
...
Try the combobox Dropdown method.

--
Jim
"Nigel" wrote in message
...
| Hi All
| Is there a way for a UserForm ComboBox (set a list) - drop down to be
| triggered from code?
|
| Presently the dropdown arrow must be clicked by the user, I would like
the
| list to open automatically.
|
| TIA
|
| --
|
| Regards,
| Nigel
|
|
|
|