Custom error-message for MatchRequired ComboBox
 

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.

Custom error-message for MatchRequired ComboBox
 

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

Gert-Jan wrote:

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.

--

Dave Peterson