Excel: Conditional Expression For Radio Button

I have two controls in my form and each has a radio button. In control 1 the user selects "No", then I want control 2 to automatically select "No" for the radio button. If the user selects "Yes" in control 1 then I want control 2 to do nothing and have the user the option to pick "Yes" or "No" Will I have to build IIF statement in control 2 in the Validation Rule property? Or something in the Event properties?

This question generated 65 answers. To proceed to the answers, click here.

This thread is current as of July 18, 2014.

For more resources for Microsoft Excel