Checkbox doing one action when checked and another when not

[zerdan]

This should be easy. I have read through the forums and found many examples of this and it seems very straight forward. I have used the examples other people have had without success.

What I'm trying to do seems pretty simple to me. I want a checkbox on one sheet (let's call it "A"). When checked it will add a series of 1's to a column in a different sheet (let's call it "B"). When unchecked it will clear these 1's that it added.

Sub CheckBox1_Click()
    With Sheets("B")
        If CheckBox1 = True Then
            .Range("A2:A12").Value = 1
        Else
            .Range("A2:A12").Clear
        End If
 End With
End Sub

With this I can clear the Range no problem, but I cannot add the 1's. Any suggestions? I'm stuck. It seems like it just skips the If CheckBox1 = True Then line.

 

[zerdan]

So I figured out where a lot of the confusion was coming. Apparently, none of the ActiveX stuff is supported on Mac so you only have the form controls. They really dumb down those even and make them difficult to use.

I have since switched to using Excel on windows and things are running very smoothly now. Thanks for the help!