Excel 2007 : Add an alert message to a radio button in a group

[Data2link]

I have a self-assesment worksheet that has Yes/No radio buttons. What I want to do is make it so if they click the "No" radio button instead of "Yes" a message will pop up and tell them to explain how they are going to come into comliance. Any help would be greatly appreciated.

[pike]

Hi Data2link

Welcome to the forum

try...

Please Login or Register  to view this content.

[Data2link]

Hi Data2link

Welcome to the forum

try...

Please Login or Register  to view this content.

Ok thanks- I will try that...I put it as a macro and just asignd the macro to the "No" toggle button right? Or if not- where do I put that code?

Thanks for the help - and thanks for the welcome!

[pike]

hi Data2link
No new to quote back as its just clutter. can you post the workbook?

[Data2link]

I wish I could post it but I can't- It's security related- I made a generic one though to show you what I'm looking for - I want a message to pop up if any of the NO buttons are clicked

Thanks again

[pike]

OK Radio buttons always confusing - option button
the assign maro will be like

Please Login or Register  to view this content.

[Data2link]

Thanks for the code. For some reason when I add this macro, when I go in to assign it to the NO option button it's not there?

[pike]

hmmm. it works for me
see attachment

Please Login or Register  to view this content.