Dynamic Reference a collection

[Puertorekinsam2]

I have six collections of auto generated user form controls

Dim MainLabels As Collection
Dim Metric1 As Collection
Dim Metric2 As Collection
Dim Metric3 As Collection
Dim Metric4 As Collection
Dim Metric5 As Collection

And I know I can add a control with this type of code:

MainLabels.Add ctrl, ctrl.Name

But what I would like to do use a variable to indicate which collection I am adding to:

Collection.name(Metric & i ).Add ctrl, ctrl.Name

I just can't find anything on line that tells me how to do this.

I know I could do this with just the naming of the controls:

Set ctrl = Me.Controls.Add("Forms.Label.1", "Metric_& i & "_barline" )

but later on this will be less elegant than I had originally hoped.

 

[Kyle123]

Why not just create a collection of collections?

 

[Puertorekinsam2]

Why not just create a collection of collections?

I was at lunch and saw this response... I was going to come back and say I don't think you understood what I wanted to do. Luckily, on the way back I realized exactly what you meant. Not what I was thinking, but very clever .


Thank you!

 

[Kyle123]

Glad it helped