Call variable from String

**juancamilo87** · 11-18-2010, 04:14 PM

Hi,

I'm trying to do something like the indirect function on the sheets but on VBA. I have a variable that it's value is a String and it's the name of another variable and I'm trying to call the variable.

Ex.

Sub a()

Dim SM
Dim name

SM = 1

name = SM

msgbox("name")

End Sub

I'm expecting a message box with the value of the variable SM but I don't know how I can do this or if it is even possible.

Thanks

,

juancamilo87

**TMShucks** · 11-18-2010, 04:41 PM

Sub a()
Dim SM
Dim name
SM = 1
name = SM
MsgBox name
End Sub

This code will display a messagebox with the prompt = 1

Regards

**juancamilo87** · 11-18-2010, 04:55 PM

I didn't know that work.

Actually what I'm needing is this.

Sub d()

dim name23
dim sm

name23 = 2
sm = "e23"

msgbox "nam"&"e23"

End sub

And I'm looking for the result 2.

Thanks

**Fo_Fa** · 01-20-2011, 04:24 PM

maybe if you described the problem you are trying to solve, a solution would present itself.
The combining strings as variables names just doesn't sound like the real problem.

**mudraker** · 02-03-2011, 12:03 AM

When using variables do not enclose them within "
msgbox name23 & sm
or
msgbox name23 + sm
or to put a space between the variables
msgbox name23 & " " & sm