VBA to show/hide radio buttons

[NewUser2]

Hi, I have an excel page that a user will be inputting information to generate some result. In this page i have a section that says: "Is this a quarterly report?" followed by a drop down list with "Yes" or "No". If they click yes, I have 4 radio buttons beside it that they can click depending on which quarter it is.

Is there a way to make these buttons visable if cell B2 (the "Yes", "No" list) = "Yes", then hide them if B2 = "No", by modifying the VB code for each button?

Thank you in advance for your help!

 

[bfreescott]

You'll want to leverage the Worksheet_Change Event and use either the visible or the enabled property of the optionbutton. Personally, I would go with the enabled property to show the users that there are additional options once they select Yes.

 

[NewUser2]

So I am not really sure how to do that... I am using Excel 2007. When I right click the button I get 2 options, 1. Assign Macro, 2. Format Control.

Under format control there isnt anything that has to do with visability, or enabling. In fact, there are very limited options under formatting.

Thanks,

You'll want to leverage the Worksheet_Change Event and use either the visible or the enabled property of the optionbutton. Personally, I would go with the enabled property to show the users that there are additional options once they select Yes.