Looping thru Checkboxes in a worksheet

[sharshra]

I have to loop thru check boxes in a worksheet & was searching for a solution. I found the following post from mrexcel excel questions forum. Post #2 is exactly what I need.

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

But, when I use this, I´m getting an error shown below. Not sure what is going wrong. Can the experts in this forum help please?

Link to a post from mrexcel excel questions forum:
[VBA] loop through all check box buttons on a sheet

Error:

 

[sharshra]

I executed the code above & it didn´t throw any error. My code is working now.....hurrah!! No changes made in the actual code Not sure why it was throwing error before & working now. However, the puzzle remains - moving from one to another

The original question on looping thru checkboxes is solved anyway. I will mark this as solution.

Thanks a lot for Domenic, Jaafer You made my day!!!

 

[Domenic]

That's great, glad you've sorted it out.

Cheers!