Table1_Label = "Table1: MAOP x " & TestMs(1) & " = " & MinTestPs(1) & " psig"
Table2_Label = "Table2: MAOP x " & TestMs(2) & " = " & MinTestPs(2) & " psig"
Table3_Label = "Table3: MAOP x " & TestMs(3) & " = " & MinTestPs(3) & " psig"
Table4_Label = "Table4: MAOP x " & TestMs(4) & " = " & MinTestPs(4) & " psig"
Table5_Label = "Table5: MAOP x " & TestMs(5) & " = " & MinTestPs(5) & " psig"
Table6_Label = "Table6: MAOP x " & TestMs(6) & " = " & MinTestPs(6) & " psig"
It would be really nice if I could use some function that would allow the following in place of above.
For i = 1 to 6
SomeFunction("Table" & i & "_Label") = "Table" & i & ": MAOP x " & TestMs(i) & " = " & MinTestPs(i) & " psig"
Next
The TableX_Label variables are UserForm Labels. Just wondering if there was a way to accomplish this without a User Defined Collection or looping through UserForm objects. Maybe I'm looking for easier ways to do things when I should just use what I know and maybe I just lack a more in depth understanding of VBA but either way it seems like it would be useful to have some way to do this.
Bookmarks