Checkbox select all, but only for a specific group of checkboxes

[Aviles]

Hi all,

I have this code which checks/unchecks all of the checkboxes in my worksheet:

Sub SelectAll()

    Dim xCheckBox As CheckBox
    For Each xCheckBox In Application.ActiveSheet.CheckBoxes
        If xCheckBox.Name <> Application.ActiveSheet.CheckBoxes("chkMasterB").Name Then
            xCheckBox.Value = Application.ActiveSheet.CheckBoxes("chkMasterB").Value
        End If
    Next

End Sub

However, I have 2 columns with 10 checkboxes in each column and I would like to have 2 separate "select all" checkboxes for each column so they work independent of each other.

So one select all checkbox for all of the checkboxes in column A, and another select all checkbox for all of the checkboxes in column B.

I'm guessing I would have to name each checkbox individually but I'm not sure how to do this.

Thanks for your help.

 

[dmt32]

Hi,
as it looks like you are using Form Control Checkboxes, have a look at this thread:Tick all in a selection of checboxes

which had a similar requirement to yours & see if any help to you

Dave

 

[Aviles]

Hi,
as it looks like you are using Form Control Checkboxes, have a look at this thread:Tick all in a selection of checboxes

which had a similar requirement to yours & see if any help to you

Dave

Wow, thank you Dave, exactly what I was looking for!