Hi Michael

You must change the "Style" to dropdownlist in the properties

See the help for MatchRequired

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.



--
Regards Ron de Bruin
http://www.rondebruin.nl



"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