View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
[email protected] KenCowen@cox.net is offline
external usenet poster
 
Posts: 14
Default loop through class module

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