Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
CLASS MODULE & SIMPLE MODULE | Excel Discussion (Misc queries) | |||
Class Module vs Normal Module | Excel Programming | |||
class module? | Excel Programming | |||
Class module | Excel Programming | |||
Variable from a sheet module in a class module in XL XP | Excel Programming |