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?

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?

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