Evaluate a string's contents as a variable?

[Oorang]

You know, I could have sworn there was a simple way to do this. And I thi nk I might even have done it once, but I just can't remember how or find it again. I wanted to be able to evaluate the contents of a string variable as a variable. What I was envisioning was something like the code below, which would display "bar". Does anyone know of a why whereby this could be accomplished?

Sub Example()
    Const x As String = "foo"
    Const foo As String = "bar"
    MsgBox MAGIC_FUNCTION(x)
End Sub

 

[Oaktree]

You may have used nameref in the Korn shell in Unix, but I don't think you can do this with VBA...