How to iterate through controls in VBA/Excel?
February 22, 2007 4:34 PM Subscribe
How do I loop through a bunch of controls using VBA in Excel 2003?
posted by apark to Computers & Internet (4 answers total)
I have a sheet w/ a bunch of option buttons on it. I would like to be able to use a loop and set their values.
I have a bunch of OBs named OptionButton1, OptionButton2, etc...
I want to do something like...
For i = 1 to 10
controls(OptionButton & 1).value = True
Unfortunately the collection "CONTROLS" seems to be available only in VB and not in VBA... Can someone help?