Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two responding dialogue boxes for data validation
Any idea how to have the data validation be giving two different messages
depending upon the situation e.g. when Cell A1 is inserted with a text, message box pops up "Please insert only a correct date" and upon inserting a date like 28-Aug-96, "Minimum age should be 20 years"? Thanx |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two responding dialogue boxes for data validation
A data validation wouldn't be able to store two error messages. However, you
can have an Input message stating the below, then have the error message state that invalid data was entered... Otherwise, you'd want to use a different control... "FARAZ QURESHI" wrote: Any idea how to have the data validation be giving two different messages depending upon the situation e.g. when Cell A1 is inserted with a text, message box pops up "Please insert only a correct date" and upon inserting a date like 28-Aug-96, "Minimum age should be 20 years"? Thanx |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Two responding dialogue boxes for data validation
Can't I even have any macro for the same?
"Sean Timmons" wrote: A data validation wouldn't be able to store two error messages. However, you can have an Input message stating the below, then have the error message state that invalid data was entered... Otherwise, you'd want to use a different control... "FARAZ QURESHI" wrote: Any idea how to have the data validation be giving two different messages depending upon the situation e.g. when Cell A1 is inserted with a text, message box pops up "Please insert only a correct date" and upon inserting a date like 28-Aug-96, "Minimum age should be 20 years"? Thanx |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Data Validation drop down boxes, retreiving numbers | Excel Worksheet Functions | |||
Data validation boxes, outputting a final number from the boxes | Excel Discussion (Misc queries) | |||
Changing Where Data Validation List Boxes Open in Mac Excel 2004 | Excel Discussion (Misc queries) | |||
Check Boxes & Data Validation | Excel Discussion (Misc queries) | |||
Data Validation list boxes | Excel Discussion (Misc queries) |