View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default OLE Combobox: Excel breaks down when it has focus

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



wrote in message
oups.com...
That works perfectly.

Thanks Tom,

Another question about OLE Comboboxes: I am having trouble with the
MatchRequired property.

I set it to true for one of my comboboxes but it doesn't appear to do
anything. The user can click in the combobox, type whatever they want
and then move on. How is it supposed to behave when MatchRequired=True?
Thanks,