Execute the contents held within a variable

[ds2728]

Hello,

I would like to execute the contents of a variable within my code. simple example is:

counter= 10
newvar = "counter + 5"

how do I get newvar to equal 15.

thanks,
dave

 

[Guest_imported]

Lose the quotes...

Sub test()
Dim counter as Long
Dim lngNewVar as Long

lngCounter = 10
lngNewVar = lngCounter + 5

MsgBox lngNewVar
'Returns 15

End Sub