Check if an input in a userform is contained in a column of a target sheet

[emymeeky]

I have a userform which I use to enter item names and their corresponding cost and selling prices. Now, to avoid duplication of items, I would want some macros which will check if an item in a text box( named drug) already exists. If it exists, let it display a message box telling the user that the item already exists.
here is a little detail about the structure:

1. text box is labelled ," Drug"
2. They are stored in a sheet named, "database"
3.The item names are contained in column A starting from the 3rd row

In summary, I want to check if the input in text box named "Drug" is contained in column A of "database" sheet"
Thanks.
Chris.

[Mumps1]

Hi Chris. Place this code in the code window for your userform.

Please Login or Register  to view this content.

[Mumps1]

Hi Chris. Place this code in the code window for your userform.

Please Login or Register  to view this content.

[emymeeky]

Thanks . That was helpful .

[Mumps1]

My pleasure.