Macro that unchecks boxes if checked

[Amber]

Hi,
I have created a macro that is supposed to uncheck a group
of five boxes if anyone is checked. Problem being I don't
know how to write it so it only unchecks the ones already
checked. CAN ANYONE HELP? Thank you in advance. Amber

 

[mudraker]

As there is 2 types of check boxes that are different in the way the
are referenced .. please post the code that you are using to unchec
the check boxe

 

[Amber]

Dear Mudraker,
The type of box I'm using is the kind that says true or
false behind it. Right now I don't have anything in my
macro to clear them.
Thank you
amber

 

[Amber]

The box is the kind that if you check it, it reads True
in background. Currently I have nothing in my macro to
clear the box, because only a few will be checked at a
time, so I don't know how to make it clear only the
checked boxes. Thankyou
amber

 

[mudraker]

Amber

Assuming you have 10 check boxes and they refer to cells a1 to a10 the
you can use this code


Sub ddd()
Dim c As Range

For Each c In Range("a1:a10")
If c.Value = True Then
c.Value = False
End If
Next c
End Su