Hello there,
Try this
- Select the worksheet that contains the checkbox
- Right click on the worksheet's tab
- Select the View Code option
- In the space provided, copy and paste the above code I provided. Anything that appears in green is a comment I left to help you understand.
- Exit out of the Visual Basic Window
- Change the cell in F6, you should see the checkbox appear and disapear based on the criteria in the code.
Please note: This code assumes that you have an ActiveX checkbox on your worksheet and it's name (different from caption) is Checkbox1.
Bookmarks