ComboBox "Not In List" Warning

[collis47]

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

 

[NickHK]

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

NickHK

 

[collis47]

I could, but that would not work with the process,

What I want is if the entry is not in the list for it to warn the data
entry person that they have to add this item into the other sheet, but
i still want them to be able to finish there current entry before going
to add the item,

eventually i want if the item is not in the list then the entry will
continue , and when it is entered with the ok button then it open up
the "FormAdAsset" and put the new serial number into the "TextSerialNo"
field so that the asset can be added

so really the msgbox warning is just a interm until i have the time to
write the code for what i really want it to do, which will just be an
extension to the warning code im after

make sense?

cheers

 

[NickHK]

Why not provide a Search Text box then, as you neither wish to limit to
existing entries nor allow new entry unconditionally.
The entry in the text box can be matched to the WS list (VLOOKUP/MATCH etc)
or the combobox.list items, during the TextBox_Change event.

NickHK