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,
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,