I am trying to get a numberic value of a string variable that is , for example "3 + 6 + 7 - 9 * 2"
What I want this to do is evaluate this as a mathematical value and assign it to a number value
The following does not work
dblValue = Val(strEquation)
This value gets returned as the first number in the sequence of the string variable (in this case it will equal 3)
I also tried removing the spaces as well as putting in parentheses. It doesn't work.

Is there another way or something I'm missing? It would really help me out. Thanks.