Macro Substitution

[JCarmic]

Is it possible in VBA to store the name of a variable in another variable and then access
the value of the first variable through the second (just like macro substitution in Xbase)

ie VarA = 10
VarB = "VarA"

Value is &VarB

 

[Atomic Shrimp]

I think you're after the Eval function:

VarB = Eval("VarA")

Mike