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

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

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