Userform Combobox on click display dropdown menu

[FuNeS13]

Can it be done? I have a Userform with several combo-boxes, I want to know if it's possible to display the combobox dropdown menu by clicking on the actual combobox rectangle, not just on the dropdown arrow key... Does it make sense?

 

[My Aswer Is This]

You can use the keyboard up down arrow keys if you want.

 

[Yongle]

Try this
- the dropdown list appears when user hovers over Combobox1 - amend to match the name of the combobox

Private Sub [COLOR=#ff0000]ComboBox1[/COLOR]_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
   [COLOR=#ff0000]ComboBox1[/COLOR].DropDown
End Sub

 

[FuNeS13]

Try this
- the dropdown list appears when user hovers over Combobox1 - amend to match the name of the combobox

Private Sub [COLOR=#ff0000]ComboBox1[/COLOR]_MouseMove(ByVal Button As Integer, ByVal Shift As Integer, ByVal X As Single, ByVal Y As Single)
   [COLOR=#ff0000]ComboBox1[/COLOR].DropDown
End Sub

I love it! You are awesome my friend!

 

[Yongle]

thanks for the feedback