ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   VBA Variables as Strings (https://www.excelbanter.com/excel-programming/421500-vba-variables-strings.html)

JeremyJ

VBA Variables as Strings
 
Is it possible to create a variable with the value being a String of a VBA
name?

Var1 = whatever

Var2 = "Var1"

I have data in my sheet with values identical to variable names in my code.
I thought this maybe one way I could reference or find those cells.

Bob Phillips[_3_]

VBA Variables as Strings
 
No, you can't, but perhaps you could create workbook names with that name
and store values in there.

--
__________________________________
HTH

Bob

"JeremyJ" wrote in message
...
Is it possible to create a variable with the value being a String of a VBA
name?

Var1 = whatever

Var2 = "Var1"

I have data in my sheet with values identical to variable names in my
code.
I thought this maybe one way I could reference or find those cells.





All times are GMT +1. The time now is 11:25 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com