Combo box match required
 

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?

Combo box match required
 

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

--
Regards,
Tom Ogilvy
dg wrote in message
...
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?

Combo box match required
 

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

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

dg wrote:

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?

--

Dave Peterson