Reset a Check Box

[mhart210]

I need some help in resetting checkboxes. I have a button that resets cells, but I also want several checkboxes to be reset to unchecked when the button is pressed. Is there some code I can add to the button to make this happen?

Thanks in advance.

[Leith Ross]

Hello Mhart210,

These code examples work with the Forms CheckBoxes. Use the constants xlOn and xlOff rather than True or False. Substitute your CheckBox names into the code below.

Examples of Checking and UnChecking:

ActivveSheet.CheckBoxes("Check Box 1").Value = xlOn
ActiveSheet.CheckBoxes("Check Box 1").Value = xlOff

Example of Clearing All CheckBoxes on the Active Sheet:

Sub ClearCheckBoxes()

 'Clears All Forms CheckBoxes on the ActiveSheet
  With ActiveSheet
   If .CheckBoxes.Count = 0 Then Exit Sub
     For I = 1 To .CheckBoxes.Count
       .CheckBoxes(I).Value = xlOff
     Next I
  End With
  
End Sub

Sincerely,
Leith Ross

[mhart210]

Thank you so much. It worked great.