View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
FARAZ QURESHI FARAZ QURESHI is offline
external usenet poster
 
Posts: 553
Default 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