Force dropdown on combobox on userform

[Giordano Bruno]

I think this may be impossible, but my userform has only a combobox and a couple of command buttons. I want the user to click a button to open the userform and have it open with the dropdown list displayed without the user having to click the down arrow.

Any thought would be much appreciated.

 

[MickG]

Try:-

Private Sub UserForm_Activate()
Me.ComboBox1.DropDown
End Sub

 

[Giordano Bruno]

Hi Mick,

Worked first time out of the box. Many thanks for that. It's a great help

 

[MickG]

You're welcome