Macro that unchecks boxes if checked

  • Thread starter Thread starter Amber
  • Start date Start date
A

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
 
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
 
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
 
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
 
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
 
Back
Top