On Fri, 18 Jul 2008 20:30:14 +0100, "Forum Freak"
wrote:

I have a userform with a combobox whos "match entry" property is set to
True. If the user enters invalid text they get a microsoft forms message
saying invalid property value.
How do I change the message to something more meaningful.

There is not built in way to change that message.

I have an alternate suggestion. Change the Style property from Combo to
DropDown. That will prevent the user from entering invalid characters and
obviate the need for a message.

If you still want to roll your own, you'll need to set MatchEntry to False,
then use the Change event to cycle through the list to determine when an
invalid character is entered. Unfortunately, Excel doesn't have a NotInList
event like Access.

If you like, I can write some basic Change event code that will get you
started.
--
Dick