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
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
Hello Peter,
Try this...
Sincerely,![]()
Please Login or Register to view this content.
Leith Ross
That's fantastic. Thanks Leith!![]()
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks