mtheriault2000
Well-known Member
- Joined
- Oct 23, 2008
- Messages
- 826
Hello again.
An un-resolved question http://www.mrexcel.com/forum/showthread.php?p=2802362&posted=1#post2802362 for me, So I will post it using another formulation
A cell contain the name of a declared variable to be read. How do i use the content of a cell as the name of a variable
EX:
variable:
Market = "Eur.Usd"
Scale = "3 Minutes"
Cell A1 = "Market"
Cell A2 = Scale
I want a string to be built using content of the variable name contained in cell A1 and contained in cell A2
String = Market & "," & Scale
String = "Eur.Usd,3 mintutes"
I want to use the value of a cell as the name of the variable to be read
If I inverese the value of cell A1 and A2 then the string will equal:
A1 = "Scale"
A2 = "Market"
String = "3 Minutes,Eur.Usd"
How do I use the text value of a cell as the name of a variable to be read. The text could represent the name of an Integer Variable also
Hope I'm clearer
Martin
An un-resolved question http://www.mrexcel.com/forum/showthread.php?p=2802362&posted=1#post2802362 for me, So I will post it using another formulation
A cell contain the name of a declared variable to be read. How do i use the content of a cell as the name of a variable
EX:
variable:
Market = "Eur.Usd"
Scale = "3 Minutes"
Cell A1 = "Market"
Cell A2 = Scale
I want a string to be built using content of the variable name contained in cell A1 and contained in cell A2
String = Market & "," & Scale
String = "Eur.Usd,3 mintutes"
I want to use the value of a cell as the name of the variable to be read
If I inverese the value of cell A1 and A2 then the string will equal:
A1 = "Scale"
A2 = "Market"
String = "3 Minutes,Eur.Usd"
How do I use the text value of a cell as the name of a variable to be read. The text could represent the name of an Integer Variable also
Hope I'm clearer
Martin