Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Search for a specific entry in a long data validation list | Excel Discussion (Misc queries) | |||
APPROXIMATE SEARCH OF ANY ENTRY IN A COLUMN | Excel Worksheet Functions | |||
matched entry complete not working | Excel Programming | |||
Search Column - Find Multiple Entries - Sum Then Delete to Single Entry | Excel Programming | |||
search column for specific cell using vba | Excel Programming |