Variable name in string variable

[Erik Schweighofer]

Is it possible to access a variable with name in another variable?

vara="varb"

How to access the value of varb?

Thanks

Erik

 

[Peter]

I don't think it's possible.
Access has the Eval() function, but I don't think it will return the value of a variable. It's supposed to be able to return the value of a function, but in playing around with it I haven't been able to get it to do that. I always get RTE 91.
Consider using a Collection or array.

-Peter

 

[Tushar Mehta]

I don't believe that's possible. Maybe, if you explain the broader
scope in which you want to do this, someone may be able to suggest an
alternative.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions