View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Carlee Carlee is offline
external usenet poster
 
Posts: 155
Default Search Specific Column for a matched entry

Hello All,

I use the code listed below to insert values entered on a UserForm, into the
next empty row in the 'Stockpile Reading Log'. Everything works great except:

Before the entry on the user form is added to the 'Stockpile' sheet, i want
the system to take the date entered in the 'Reading Date' field of the user
form, and search column 'A' of the 'Stockpile Log'. If the date exists
already in the column, i want the system to alert the user that the date
already exists, and cancel the process. I do not want rows to be entered
into the sheet that contain a date that already exists.

Can anyone help me with this request?
--
Carlee