Combo box match required

[dg]

The match required property for a combo box does not work
in excel 2002.
ie - you can hardcode a value that is not in the list
source.

What is the workaround?

 

[Tom Ogilvy]

Wasn't aware of that, but how about restricting the user to selecting from
the list (or use a listbox).

 

[Dave Peterson]

If you change the .style property to fmStyleDropDownList (instead of
fmStyleDropDownCombo), does it work better?

(Does "hardcode a value" mean type it in?)