I'm trying to build a loop that automatically sets the values of a group of check boxes based on information in an Array. How can i generate the name of the current checkbox name in this loop, it's abit hard to explain but hopefully you can see what i'm trying to do from the code :


GetSites 'Calls a function that gets all the values

For i = 1 To 12
Check&i.Value = Sites(i)
Next i