[VBA] loop through all check box buttons on a sheet

[smallxyz]

I have 10 checkboxes on a sheet.

Their names:

ck_1
ck_2
ck_3
ck_4
ck_5
…
ck_10



Instead of setting

ck_1.Value = False one-by-one

Is there a way to loop through all these check box buttons which have specific names?

Thanks!

 

[Domenic]

If your checkboxes are Form controls, and you don't have any other checkboxes on your worksheet, you can set them all to False with a single line...

Worksheets("Sheet1").CheckBoxes.Value = False

If your checkboxes are Form controls, and you need to loop through your checkboxes, try...

    Dim i As Long
    
    For i = 1 To 10
        Worksheets("Sheet1").CheckBoxes("ck_" & i).Value = False
    Next i

If your checkboxes are ActiveX controls, try...

    Dim i As Long
    
    For i = 1 To 10
        Worksheets("Sheet1").OLEObjects("ck_" & i).Object = False
    Next i

Change the sheet name, accordingly.

Hope this helps!

 

[smallxyz]

Very helpful information and solution,Domenic !
Thank you so much.
I always confuse myself how to access to ActiveX, Form controls.
It clears my cloud now. Thanks!

 

[Domenic]

You're very welcome!

Cheers!