tick all checkboxes automatically

slim

New Member
Joined
Feb 24, 2002
Messages
42
is there an easy way to put a tick in every checkbox (30 of them) all in one go?

tried for 'each checkbox in checkboxes' but it wasn't happy.
 

Some videos you may like

Excel Facts

What is the last column in Excel?
Excel columns run from A to Z, AA to AZ, AAA to XFD. The last column is XFD.

Andrew Poulsom

MrExcel MVP
Joined
Jul 21, 2002
Messages
73,092
There isn't a collection of Checkboxes. Rather, there is a collection of Controls.

Code:
For each Ctrl in Controls
   If TypeName(Ctrl) = "Checkbox" Then
'  *** Whatever ***
   End If
Next Ctrl
 

Watch MrExcel Video

Forum statistics

Threads
1,119,002
Messages
5,575,486
Members
412,669
Latest member
nickyon1
Top