Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
validation date
Anyone know where I can find code for validation of the
date. ie. user enters in mmddyyyy, I want to ensure that the values they enter make sense (eg. month cannot be 33, has to be between 1-12) thx. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
validation date
Try the isDate function.
if(isdate(your date))then ....do your thing endif or if(not isdate(your date))then Msgbox "This is not a valid date" exit sub endif etc... Hope that helps! Kevin -----Original Message----- Anyone know where I can find code for validation of the date. ie. user enters in mmddyyyy, I want to ensure that the values they enter make sense (eg. month cannot be 33, has to be between 1-12) thx. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
DATE VALIDATION | Excel Discussion (Misc queries) | |||
date validation | Excel Worksheet Functions | |||
Date Validation - Must equal Sundays date | Excel Discussion (Misc queries) | |||
Date Colum Date Formatting & Validation | Excel Programming | |||
Date Validation | Excel Programming |