Checking and Unchecking multiple check boxes at once

Hi Everyone,

I'm trying to make a macro where if I check/uncheck a check box a group of checkboxes also be checked/unchecked.

I have 10 check boxes that are labeled chkBoxQ_1_L_1 all the way to Q_1_L_10

The way I'm thinking to write the code is like this:

Private Sub chkBoxQ_1_L_1_Click()

If chkBoxQ_1_L_1.Value = True Then

'here would be a loop that cycles through chkboxQ_1_L_2 to chkboxQ_1_L_10 and checks them

Else

'here would be a loop that cycles through chkboxQ_1_L_2 to chkboxQ_1_L_10 and unchecks them

End if

End Sub

Any ideas how to write the loop? help is appreciated thanks

Hey, I used this website when I need to do this earlier this year. It explains it pretty well. Have a look.

http://www.exceltrick.com/how_to/sel...ngle-checkbox/

If you only want to apply the code to your 10 boxes above, perhaps this will work:

Please Login or Register  to view this content.

Hi PD Bartlett,

the controls method doesn't seem to be a member of the "me" group. do you have any other suggestions?