Need to clear or set all check boxes

[trixmot]

Excel XP
In order to reset the form I have created, I need an easy way to reset all the check boxes to be unchecked. I have macro to clear the values in the cells next to the checkboxes, but I also want to clear the check mark.

Thanks in advance for any help you can provide.

 

[Norie]

What type of checkboxes do you have?

Are they on a userform?

If they are you could try something like this.

Dim ctl As MSForms.Control

    For Each ctl In Me.Controls
        If TypeName(ctl) = "CheckBox" Then
            ctl.Value = False
        End If
    Next ctl