William C Johnson
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
Private Sub PWNoOptionButton_Click() section?
Thanks,
Bill J.
New-Site-Form-Sample.jpg
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER