Combobox

[Nigel]

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

 

[Jim Rech]

Try the combobox Dropdown method.

--
Jim
| 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
| (e-mail address removed)
|
|
|

 

[Nigel]

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