Can you not just set the combobox.Style to fmStyleDropDownList ?
Then the entry must be in the list.

NickHK

wrote in message
oups.com...
Ok I have had a look arround, and nothing seems to be what i need, and
what seems like i need doesnt make sense.

What I require is code so that if an entry that is put into a combo box
is not in the "rowsource" list then I would like a message box to
appear to warn the data entry person,

my rowsource is a range called "SerialMaster" and my combobox is called
"ComboSerialNo"

Any help would be greatly apprechiated