Show Combobox items when entering

[sharky12345]

Is there a way to show the items in a Combobox when the user clicks in the box itself, in addition to the usual dropdown arrow? This is on a Userform, not a worksheet.

 

[Rick Rothstein]

Is there a way to show the items in a Combobox when the user clicks in the box itself, in addition to the usual dropdown arrow? This is on a Userform, not a worksheet.

Use the ComboBox's DropDown method in its Enter event...

Private Sub ComboBox1_Enter()
  ComboBox1.DropDown
End Sub

Note: This seems to only work when the ComboBox does not get focus immediately upon the UserForm being shown. I could not find an event to use to make this work if the ComboBox got the focus immediately.

 

[sharky12345]

Thanks Rick - that's exactly what I need.