ComboBox Restrictions

[rhombus4]

Have a few comboboxes on a form and have tried both options below which do work and restrict entries.

However what if I enter a dropdown by mistake and then decide I didn't want to and I want it to be cleared, it wont let me clear the selection.
The only workaround is possibly to add a space at the top of the named range so you could select that instead, but was wondering if there is an easy way maybe in the properties or something I could set at initialisation


Set MatchRequired to True - Allows you to type in the combo box, but limits the entry to the defined range.
Set Style property to fmStyleDropDownList - Can't type, but limits the entry to the defined range.

Not sure if there is a big difference between the two options or which one is the best

 

[Worf]

Hello

Private Sub UserForm_Click()
Me.ComboBox1 = ""
End Sub

Private Sub UserForm_Initialize()
Me.CheckBox1.TabIndex = 0
Me.TEXT1.TabIndex = 1
Me.TextBox2.TabIndex = 2
Me.TextBox3.TabIndex = 3
Me.ComboBox1.Style = fmStyleDropDownList
Me.ComboBox1.List = Range("b14:b18").Value
End Sub

 

[mikerickson]

You could just use the backspace to clear the entry
or you could use the double click event.

Private Sub ComboBox1_DblClick(ByVal Cancel As MSForms.ReturnBoolean)
    ComboBox1.ListIndex = -1
End Sub