Excel - using variables in object names

[kaplin]

I'm new to forms - how do I use a variable when calling a series of checkboxes.

Ex:

dim count as integer
dim titles(20) as string

for count = 1 to 20
titles(count) = myForm."checkbox" & count.caption
next count

 

[RobBroekhuis]

No can do. This is so common, someone should write a FAQ! Usually the solution is something like

dim count as integer
dim titles(20) as string
dim ctrl as object

for each ctrl in myForm.controls
if left(ctrl.name)="checkbox" then
titles(val(mid(ctrl.name,9))) = ctrl.caption
end if
next ctrl
Rob

 

[kaplin]

Wow - and to think it sounds like such a simple question!

Thanks.