I think I know the answer, but I don't like it....

Here it is, lets say I have a bunch of activeX controls, all with the same name only a number (1 through 20) on the end. For example: ActiveXControl1, ActiveXControl2, ActiveXControl3, ....., ActiveXControl19, ActiveXControl20. Now what I want to do is loop through each object using a for loop or something along those lines. I know I can't do:

for i =0 to 20
ActiveXControl & i.someMethod (someArg)
next i

What can I do? If anything....
:confused:

If the controls are on a form (or forms) - each form has a Collection called Controls -

Code:

---

Dim ctl as Control
For each ctl in Form1.Controls
      if left(ctl.Name,10)="ActiveXCon" then
            ' do something with the control
      end if
next

---

Make it a control array by changing the index property of each to a number.

Then you can just loop through a counter saying

ActiveXControl(counter).proerty = something


It also allows you to very easily expand the program later with more controls rather than rewriting it all each time.