Collection index -XL2000

[BarryG]

I'm trying to refer to a member of a collection by using a statement for the index. Specifically, I want to move through the controls on a form by using their TabIndex properties, rather than the collection index.

I've tried:

For i = 1 to Controls.count
   Controls(TabIndex = i).Select
   'do stuff with the selection
Next i

but it doesn't work. Any ideas?

 

[ide]

try
me.Shapes.Count

 

[BarryG]

Ide,

I tried the shapes collection, but I think it only applies to objects on worksheets, not on UserForms.

Thanks anyway.

 

[ide]

no, it can be use on worksheets, too. But if your code is in a modul (not on the worksheets' code) it's necessary to specify the worksheets owing the control.
Worksheets("Sheet1&quot.shapes.count

perhaps see the

http://www.tek-tips.com/gviewthread.cfm/lev2/4/lev3/32/pid/707/qid/117523

thread