VBA to clear checkboxes and specified cells

[tdavis95]

Hello.

I currently have a clear button that successfully clears the range of cells.
I also added check boxes in my sheet (inserted from the Developer tab -> insert -> checkbox) checkboxes 15-20.
I want a way to add code in the VBA so that when it clears the text it will also uncheck the boxes. Is that something I can do?

Here is the code that I currently have:

Sub Clearcells()
Range("B6:B9").ClearContents
Range("B26:H36").ClearContents
End Sub

 

[Legal Tender]

If you just want to uncheck them all, try this:

Dim chkBox As Excel.CheckBox
For Each chkBox In ActiveSheet.CheckBoxes
        chkBox.Value = xlOff
Next chkBox