say i have this info
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
Code:
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