Control Array

[gnosis13]

Can you build a control array in VBA? I am trying to access several labels with code and would like to loop through them using a control array, however, VBA doesn't seem to support this.

Ex:
X = 0
Do Until X = 10
label[X].caption = X
X = X + 1
Loop A+, N+, MCP

 

[JohnYingling]

No support but you could build an array of controls yourself
Private aryCtl(9) as object
....
Set aryCtl(0) = label1
Set aryCtl(1) = label2
....
Dim ctl As object
For Each Ctl in aryCtl
...
Next
For X = 0 to Ubound(aryCtl)
....
next

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript

 

[gnosis13]

Thanks for the fast response. That is a very good idea and would work exactly as I need. Unfortunately, the people who will maintain this code will most likely not be skilled at that level. Thats why I was hoping that Access would handle a simple control array....oh well, they can just put up with a very long function of repetitive code!
A+, N+, MCP

 

[JohnYingling]

That is how they become skilled at that level.

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort in VB or VBScript