Checkbox for checking all checkboxes

[FTK]

What would the macro be to have a checkbox 'select all' checkboxes within a range of cells? (the checkboxes are linked to the cells)

 

[FTK]

Bump

Man this board moves fast. Again, I'm looking for a macro (I think that's the right terminology) to allow one checkbox select 'all' checkboxes in a particular column.

 

[cfree36]

What kind of checkboxes are they?

Control Toolbox or Forms?

 

[FTK]

I added the checkboxes with the 'forms' toolbar.

 

[cfree36]

Basically if you make the cells the checkboxes are linked too 'TRUE' all checkboxes will be checked
So... the following code should work.

Just assign it to a button:

Change the range to fit the range where your cell links are....

Sub CheckAll()
Dim MyRange As Range
Set MyRange = Range("H12:H16")

For Each c In MyRange
c.Value = True
Next c
End Sub

 

[FTK]

Sweet. It worked. How do I make it so when I 'uncheck' the box the cells are set to FALSE?

 

[cfree36]

Assuming H10 is the cell your master checkbox is linked too:

Sub CheckAll()
Dim MyRange As Range
Set MyRange = Range("H12:H16")

For Each c In MyRange
If Range("H10").Value = True Then
c.Value = True
Else: c.Value = False
End If
Next c
End Sub

Again change the range to fit your needs.