VBA - recognize variable via concatenation

[TheNoocH]

say i have this info

Sub test()
  vPlayer = "P1"
  colP1 = 3
  MsgBox "col" & vPlayer
End Sub

what i want to return in the msgbox is 3 ... but it's returning colP1 ... how do i get it to interpret the value of the variable rather than the string once concatenated?

thanks

 

[NBVC]

Maybe I didn't understand

but perhaps you have to take away the quotations around your variable name?

Is this what you mean?

Sub test()

  vPlayer = "P1"
  colP1 = 3
  MsgBox colP1 & " " & vPlayer
End Sub

 

[just_jon]

I don't think you can reference variables like that, dynamically, no.

 

[TheNoocH]

NBVC,
that's not what i was getting at...i wanted to reference colP1 by concatenating col & the variable from vPlayer which was P1 so i could reference colP1...but unfortunately like Jon stated...maybe it's not possible...