Uncheck Check Boxes

  • Thread starter Thread starter Sean
  • Start date Start date
S

Sean

I have 52 Check boxes (representing each week of the year) on a sheet
called Account. How can I uncheck all boxes within this sheet via code,
that will save me from clicking 52 times!

Thanks
 
Dim cb As CheckBox
For Each cb In ActiveSheet.CheckBoxes
cb.Value = False
Next cb

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
 
Forms toolbar to Control Toolbox check boxes? Always help to say.

--
Jim
|I have 52 Check boxes (representing each week of the year) on a sheet
| called Account. How can I uncheck all boxes within this sheet via code,
| that will save me from clicking 52 times!
|
| Thanks
|
 
Excellent Bob, thanks a lot

Bob said:
Dim cb As CheckBox
For Each cb In ActiveSheet.CheckBoxes
cb.Value = False
Next cb

--

HTH

Bob Phillips

(replace xxxx in the email address with gmail if mailing direct)
Click to expand...
 
Back
Top