Data Validation w/ exceptions msg box

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

TC - 22 Dec 2005 00:51 GMT

Hey,

I created a form utilizing the data validation and the Indirect function. I
have a list of products in Column A, depending on the product selected,
certain options are available in Column B. I want to create a warning
message if one of the options in Column B needs other information. Is this
possible?

Thanks,

Reply to this Message

paul - 22 Dec 2005 10:00 GMT

of course.but you will have to give us more info.You may be able to use
helper cells and an =IF(OR(B2=1,B3=1,B4=1),"Danger Will Robinson
Danger",""),formatted in
large red letters,you could use a data validation formula,you could use a
macro.....--
paul
remove nospam for email addy!

> Hey,
>
[quoted text clipped - 5 lines]
>
> Thanks,

Reply to this Message