Need help in Excel Macro

[Staruser]

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

[Bob Phillips]

Change the DV to only Yes and it will give the error message.

[Staruser]

Thanks for the help, but i want both the option and if a user select No then it shud throw an error

[Bob Phillips]

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!