PDA

View Full Version : Solved: Problem with Combo Box



peacenik
02-07-2006, 11:23 PM
I have a combo box in an excel Form that is behaving in a way I don't like.

The Combo box is being filled from a selection from a long list. That is working no problem. If the user selects a valid option no problem. If the user enters text that does not match the list, or clears the data and then moves away from the combo box, a dialog box with the text "Invalid property value" appears. This is really ugly but I havent found a way to trap this and do something more elegant instead.

thanks in advance,

Rembo
02-08-2006, 03:51 AM
Hello peacenik,


I have a combo box in an excel Form that is behaving in a way I don't like .. If the user enters text that does not match the list, or clears the data and then moves away from the combo box, a dialog box with the text "Invalid property value" appears.

Rightclick on the combobox and select properties. In the properties window look for the MatchRequired property and set it to False. This is actually the default setting but it seems like it has been set to True in your situation.

Alternatively can also set it from VBA, For example:

UserForm1.ComboBox1.MatchRequired = False

Hope that helps,

Rembo