MsgBox on Error - code needed

[Underkarolinawood]

hi,

I am using Combobox on my form to allow Users to select available items from the General Stock List. It works well but when someone is typing code name and the code is not there there is a vlookup error message. How can i amend the code so when there is an error a MsgBox is displayed to say "The item you are looking for is not on the list" and the USerForm is NOT Closing. My current code for the ComboBox is as below:

[Keebellah]

Just don't let them type, only items in the combobox, you can set that in the properties

[Underkarolinawood]

Just don't let them type, only items in the combobox, you can set that in the properties

Well, I do want to let them type as the list in ComboBox is long ( in alphabetical order) as by typing first few characters allows them to find relevant code quicker

[Keebellah]

The you'll have to use the IFERROR() integrated in the macro
Will need a sample of your file to work something out
It's past midnight here so I'm off to bed.
I quite often use a textbox where the user can start typing filters a Listbox as they type (instead of a Combobox)

[Keebellah]

Could you attach a file with non-sensitive data ?