[VBA] how to return nominal name (not content) of a variable?

[smallxyz]

[I]Sub[/I] Test[I]([/I][I])[/I]
    Var1 = 1
    Var2 = 2

    Msgbox VarName[I]([/I]Var1[I])[/I]
    Msgbox VarName[I]([/I]Var2[I])[/I]

[I]End Sub[/I]






[I]Function[/I] VarName[I]([/I][I])[/I]




[I]End Function[/I]

Preferably, the above msgbox will result in pop-up window with "Var1" and "Var2", instead of 1, 2.
Is it possible?

Thanks a lot!

 

[jmacleary]

I'm not sure why you would want this, but since you are coding the variable name in the msgbox, why not just put quotes round it? i.e.

    Msgbox VarName[I]("Var1")[/I]
    Msgbox VarName[I]([/I]"Var2"[I])[/I]

 

[smallxyz]

I'm not sure why you would want this, but since you are coding the variable name in the msgbox, why not just put quotes round it? i.e.

    Msgbox VarName[I][I][I]([/I][/I]"Var1"[I][I])[/I][/I][/I]
    Msgbox VarName[I][I][I]([/I][/I][/I]"Var2"[I][I][I])[/I][/I][/I]

Hi jmacleary,
I wish to make a function to print out the name of variable and also its content.

e.g.
A = 100
B = 200
C = "zzz"
PrintVariable(A, B, C)

A message box will show up, giving following lines of message:

variable content
---------------------
A　100
B　200
C　"zzz"

 

[Fluff]

AFAIK there is no way of doing that.
It maybe possible use Class modules, but unlikely to be simple.

 

[jmacleary]

OK. What you could do is create a 2 dimensional array with the first element being the name, and the second element being the value, and then pass that array to your function.

 

[pgc01]

Hi

If you want both the name and the value of a variable one option is to use a dictionary.