cell as option button

Searh the forum for Marlett checkboxes.

This example uses Cell B2

Please Login or Register  to view this content.

Copy the code
Select the worksheet in which you the code to run
Right click on the sheet tab and choose View Code, to open the Visual Basic Editor.
Where the cursor is flashing, choose Edit | Paste