Search for existing values in woorksheet!?
Hi all,
i need some help coming up with a code.
I have a Userform in wich users add new data to a database.
When a user enters a new post he/she needs to enter a number for
example 6501. I need a code that search the entire column ( A ) for
just this number, and if it already exist a MsgBox pops up and inform
the user!
Grateful for all help i can get!
|