Hi.
I have many definitions in my Module2. They are various as in Array's and Constants, etc.
There are a few that I have defined as Longs. Example:
Public MSL as Long
Public MSP as Long
.
.
etc
.
Can I at runtime run through the list of definitions and when I come to a match, insert a value to that definition?
Say Cell A1 in Sheet1 = MSL
Example:
For I = 1 To end of definitions in Module2
If Sheets("Sheet1").cells(1,1) = List in Module2 then
List in Module 2 = 1
Endif
Next
Perhaps this is not possible at runtime?
Thanks...
I have many definitions in my Module2. They are various as in Array's and Constants, etc.
There are a few that I have defined as Longs. Example:
Public MSL as Long
Public MSP as Long
.
.
etc
.
Can I at runtime run through the list of definitions and when I come to a match, insert a value to that definition?
Say Cell A1 in Sheet1 = MSL
Example:
For I = 1 To end of definitions in Module2
If Sheets("Sheet1").cells(1,1) = List in Module2 then
List in Module 2 = 1
Endif
Next
Perhaps this is not possible at runtime?
Thanks...