For Loop and Error Handling

[peetman]

Hi again,
I am facing a few issues with a For Loop. I have a few Checkboxes from the Forms Controls and I want to write column D the ones not selected and in column I the ones selected but are not found in some other sheet.
For that I am using a For Loop from i = 60 to 150 (the first checkbox starts in 60, I don't know why). The problem is that checkboxes are not sequential, i.e I have checkbox 60, 62, 63, 64 and so on but checkbox 61 does not exist and that blank checkbox is repeat further without any logic.
I am using the ErrorHandler which skips the error that pops-up when checkbox 61 is not found, to move to the next number and for that I do i=i+1. This will write down the right values in the right columns but freezes Excel. It goes in a continuous loop.

Could help me in skipping some values that are not found in the For Loop?

Please Login or Register  to view this content.

Thanks in advance,
Pedro

[Norie]

Couldn't you loop through the Shapes collection?

[peetman]

Couldn't you loop through the Shapes collection?

How can I do that?
I am a very basic user of VBA.