create a new variable with concatenation from the value of previous variable

[kkshansid]

I want to create a new variable with concatenation from the value of previous variable with use of concatenation

Sub test()
v1 = "2"
''create new variable v12 whose value is 3
v1.[&v1] = "3"
Debug.Print v12
'' above should print 3
End Sub

error is invalid or unqualified reference
please help

[Seth Schrock]

Line 4 is not a valid statement. I'm not sure what you are trying to do. Simple variables (like v1) don't have any properties or methods (anything after the dot). Simply entering v12 = "3" for line 4 would get the result of Debug.Print to be 3. However, there isn't any dependence on the variable v1 using this method.

Please try to explain again what you are trying to do as you can't concatenate anything with "3" and get simply "3" other than an empty string.

[Rabbit]

You can't dynamically create variable names. I don't know where you pulled that syntax from but it's not VBA syntax.

If you want to store key-value pairs where you can dynamically create the key name, use a dictionary object.

However, that's only addressing your stated request. At the root of everything, you probably don't need this sort of functionality in the first place. We don't know why you want to create dynamic variable names. If we understood why you want to do this, then there's probably an easier solution and you don't need to create these dynamic variable names in the first place.

[NeoPa]

As Rabbit says, Arrays, Collections or Dictionary Objects seem to offer the sort of thing you look like you might be after. Without better sense in the question though it's hard to guess how to help further.