Need to clear or set all check boxes

trixmot

New Member
Joined
Dec 23, 2005
Messages
1
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.
 

Some videos you may like

Excel Facts

Move date out one month or year
Use =EDATE(A2,1) for one month later. Use EDATE(A2,12) for one year later.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
76,059
Office Version
  1. 365
Platform
  1. Windows
What type of checkboxes do you have?

Are they on a userform?

If they are you could try something like this.
Code:
Dim ctl As MSForms.Control

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

Watch MrExcel Video

Forum statistics

Threads
1,118,530
Messages
5,572,697
Members
412,481
Latest member
nhantam
Top