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...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional formatting a range 5
Copied Formulas Not Working 1
how to pre define what to show on the top of the Combo Box 3
Linking Check Box in User Form to Workbook 8
Copy tab from one spreadsheet to multiple tabs in another spreadsheetwhile retaining the targets spr 15
Catching check/uncheck event accross multiple checkboxes 7
Linking textboxes with option boxes 4
need code to copy/move data between sheets 3

Back
Top