Microsoft Office Forums - View Single Post - [Solved] Asking for Macro to Reset Checkbox

Colin Legg · 12-11-2012, 06:57 AM

The way your code is trying to access it would work if it were an ActiveX control (and if it were qualified with the parent sheet in the code). Since it is a forms control, you can access it like this:

Code:

Sub Button2_Click()
    Sheet1.CheckBoxes("Check Box 4").Value = False
End Sub

Where Sheet1 is the codename of the worksheet the checkbox lives on.