use Val () function with strings that contain +,-,*,/

[wengang]

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.

[kedaman]

You will have to make a script that reads those strings and calculates them manually.

[Sam Finch]

There's something called uMath which can do it, I think it's about $100 but it's damn usefull if you need to do a lot of this stuff, otherwise, program your own. VB can't do it, I don't know where uMath is but search under Maths parser.

[gonefishin_53]

the val() function converts every digit until it encounters the first non-digit number. Valid characters aree 0-9 the sign (+ or -) and the decimal point(.)
to convert a string to a mathmatical sequence try the eval() method. It evaluates a supplied string as though it were code. As a result, you could easily evaluate mathematical expressions passed as a string, like so:

iResult = Eval("(2 * 3) + 5)")

which fills iResult with the value 11.

[wengang]

I have done some code that does this thing, but I think it's a bit slow for use. Interested?

[kedaman]

The module is at:
http://www.geocities.com/kedasu/varol.bas
It's somewhat old, I haven't used it for years. Don't worry about those swedish comments. If anyone finds it useful or finds any bugs, reply here or contact me