View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Daniel[_10_] Daniel[_10_] is offline
external usenet poster
 
Posts: 7
Default 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!