Link to home
Start Free TrialLog in
Avatar of William C Johnson
William C JohnsonFlag for United States of America

asked on

Disable Option Buttons MS Excel 2010 VBA Code

How do I disable an option button or buttons (contained in a frame) based upon the selected option button (contained in another frame).  See sample of form attached.  If the No option is selected in the "Did you" frame, I want all the option buttons in the "If you" frame to be disabled.  Vice versa, If the Yes option is selected in the "Did you" frame, I want all the option buttons in the "If you" frame to be enabled.  I need this check done every time I press one of the buttons in the "Did you" frame.  Also, please be specific in what area of VBA you place this macro.  I'm guessing in the
Private Sub PWNoOptionButton_Click() section?

Thanks,

Bill J.
New-Site-Form-Sample.jpg
ASKER CERTIFIED SOLUTION
Avatar of Wayne Taylor (webtubbs)
Wayne Taylor (webtubbs)
Flag of Australia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of William C Johnson

ASKER

This works great.  Thank you.