the help says:

Specifies whether a value entered in the text portion of a ComboBox must
match an entry in the existing list portion of the control. The user can
enter non-matching values, but may not leave the control until a matching
value is entered.

AND

If the MatchRequired property is True, the user cannot exit the ComboBox
until the text entered matches an entry in the existing list. MatchRequired
maintains the integrity of the list by requiring the user to select an
existing entry.

-------
however after that it says:

Note Not all containers enforce this property.

So perhaps the OleObject container does not. I haven't tested it.

You could change the style of the combobox and force the user to select from
the dropdown list.

--
Regards,
Tom Ogilvy


"Michael Deathya" wrote in message
oups.com...
Hi,

I am using OLE comboboxes on my worksheets in Excel 97

I am having trouble w*ith the MatchRequired property.

I set it to true for one of my comboboxes but it doesn't app*ear to do
anything. The user is still able to click in the combobox, type
whatever *they want and then move on. I need to restrict it to the
values in the ListFillRange.

How is it supposed to behave when MatchReq*uired=True?
Thanks,

Michael Deathya