checkboxes

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm looking for a way to uncheck check boxes all at once rather than one line
at a time. If I use ActiveSheet.CheckBoxes("Check Box 1").Value = 0 I'm fine
but I have about 30 check boxes I would like to do this to.

ActiveSheet.CheckBoxes.Visible = False 'this works great. It hides them all


ActiveSheet.CheckBoxes.Value = 0 'this doesn't work at all. I get
an error. Is there an easy way to make all check boxes blank? I have the
default value set to unchecked but I need to reset them sort a speak based on
other things going on.
 
I think this works

for each mybox in ActiveSheet.CheckBoxes
mybox.value = 0
next mybox
 
But your code did work ok for me.



I'm looking for a way to uncheck check boxes all at once rather than one line
at a time. If I use ActiveSheet.CheckBoxes("Check Box 1").Value = 0 I'm fine
but I have about 30 check boxes I would like to do this to.

ActiveSheet.CheckBoxes.Visible = False 'this works great. It hides them all

ActiveSheet.CheckBoxes.Value = 0 'this doesn't work at all. I get
an error. Is there an easy way to make all check boxes blank? I have the
default value set to unchecked but I need to reset them sort a speak based on
other things going on.
Click to expand...
 
Back
Top