Dropdown in vba userform

[Jefferson2512]

how to avoid a user to input text in my dropdown.. all I want is to let the user choose on my items in dropdown list and avoid the user to input text that are not belong to my items in dropdown list

 

[mikerickson]

You can set the .Style property either at design time or in the Initialize event.

Private Sub UserForm_Initialize()
    ComboBox1.Style = fmStyleDropDownList

'...
End Sub

 

[Jefferson2512]

You can set the .Style property either at design time or in the Initialize event.

Private Sub UserForm_Initialize()
    ComboBox1.Style = fmStyleDropDownList

'...
End Sub

thanks for this man morepower