Custom error-message for MatchRequired ComboBox

[Gert-Jan]

In my userforms I use often ComboBoxes, with the "MatchRequired" option to
"True". Is it possible to customize the error message when someone tries to
select something that is not in the RowSource? Now I see a awfull
Excel-error.

 

[Gert-Jan]

Found it already:

Private Sub ComboBox1_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If ComboBox1.MatchFound = True Then
Exit Sub
Else
MsgBox ComboBox1.Value & " is an invalid entry"
Cancel = True
End If
End Sub

 

[Dave Peterson]

Is there a reason not to change the .style property to fmStyleDropDownList?