View Full Version : Need help in Excel Macro

04-20-2012, 03:24 AM
i have created a list Yes/No using Data validation . Now tell me how to do this -

If i select "Yes" then nothing but if "No" then it shud give me an error msg.

Also another instance where if i select Yes then the next row will hide.

Pls if someone can help me

04-20-2012, 05:05 AM
Change the DV to only Yes and it will give the error message.

04-20-2012, 05:21 AM
Thanks for the help, but i want both the option and if a user select No then it shud throw an error

04-20-2012, 05:23 AM
If you are going to throw an error, what is the rationale for even havng that as an option?

Pick A or B! Oh, you picked B, that is not allowed. It does not compute Jim!