Loop through Checkboxes in a UserForm

[PeterWilliams]

I have, say, 20 checkboxes (let's call them CheckBox1 to CheckBox20) on a user form. Is there a way I can set up a loop to access them all?

E.g.
For i = 1 to 20
Checkbox(i).enabled = true
Checkbox(i).caption = "CBox" & i
Next i

[Leith Ross]

Hello Peter,

Try this...

Please Login or Register  to view this content.

Sincerely,
Leith Ross

[PeterWilliams]

That's fantastic. Thanks Leith!