Hello Raw,
Since all the controls on the worksheet are from the Control Toolbox and not the Forms Controls, the code needs to be changed again. That's why you are getting an error at the Option Button code. The macro was written for a Forms Option Button and not a Control Toolbox Option Button.
Next you need to call the macro from each Option Button's Click event code.
1. While in Excel, Press ALT+F11 (Open the VB Editor)
2. Press CTRL+R (Places the cursor in the Project Explorer window)
3. Click on the Worksheet the Option Buttons are on.
4. Press F7 to display the Code window.
5. Click on the Leftside ListBox's down arrow located above the Code Window.
6. Click on the name of the Option Button.
7. You will see the default Event Procedure (Example for OptionButton1) ...
8. Add the macro call using the Option Button's name...
9. Repeat steps 5 to 8 for each Option Button.
Sincerely,
Leith Ross
Bookmarks