Converting Math Expression From String to Real

[GGleason]

I would like to do something that seems to be simple to do but I don’t know how to go about it. I have a string variable (such as “8 / 4” or “50.26 + 9.7”). I would like to evaluate this expression and convert it into a real number (such as 2 or 59.76).

Is there a function within VBA to do this?

TIA,
GGleason

 

[MichaelRed]

? Eval("8 / 4&quot
2

? Eval("50.26 + 9.7&quot
59.96

MichaelRed
m.red@att.net

There is never time to do it right but there is always time to do it over

 

[GGleason]

Michael,

Thank you for the tip. Too bad a function like this does not exist in Excel.

GGleason