I have class module (Reqs) with 9 variables declared as

Public Class_01 As String
Public Class_02 As String
Public Class_03 As String
etc

I want to build a string referencing those variables, during the
initialization of a userform, in loop like

for i=1 to 9

x(i)=Reqs(emp).Class_01

next i

using something like "Reqs(emp).Class_0" & i

but I can't figure out how to make it treat the concatenated string as
a property of the class, not a string.

Can someone point me in the right direction on this?

Thanks

Ken



where I build the

Have you thought of having the 9 strings in a collection (still within
your class) variable instead?
Then:
- each item in the collection would be the string
- the key for each item would be the variable's name
and then you could call each variable by its name from the colelction
using the collection and your construct of "Class_0" & i
?

On Oct 6, 1:13*pm, wrote:
I have class module (Reqs) with 9 variables declared as

Public Class_01 As String
Public Class_02 As String
Public Class_03 As String
etc

I want to build a string referencing those variables, during the
initialization of a userform, in loop like

for i=1 to 9

x(i)=Reqs(emp).Class_01

next i

using something like "Reqs(emp).Class_0" & i

but I can't figure out how to make it treat the concatenated string as
a property of the class, not a string.

Can someone point me in the right direction on this?

Thanks

Ken

where I build the

I thought about that right I after I posted. I think that will be a
better solution.
Thanks
Ken

On Oct 6, 10:39*am, AB wrote:
Have you thought of having the 9 strings in a collection (still within
your class) variable instead?
Then:
- each item in the collection would be the string
- the key for each item would be the variable's name
and then you could call each variable by its name from the colelction
using the collection and your construct of "Class_0" & i
?

On Oct 6, 1:13*pm, wrote:



I have class module (Reqs) with 9 variables declared as

Public Class_01 As String
Public Class_02 As String
Public Class_03 As String
etc

I want to build a string referencing those variables, during the
initialization of a userform, in loop like

for i=1 to 9

x(i)=Reqs(emp).Class_01

next i

using something like "Reqs(emp).Class_0" & i

but I can't figure out how to make it treat the concatenated string as
a property of the class, not a string.

Can someone point me in the right direction on this?

Thanks

Ken

where I build the- Hide quoted text -

- Show quoted text -