If I am incorrect
Just for benefit of the OP since you have obfuscated the correct solution
provided by Harald, nothing you have said so far is correct.

Harald's method worked fine (except for including the string A in the
msgbox). Your suggestions don't work at all.

--
Regards,
Tom Ogilvy

"Ascheman" wrote in message
...
Ok if I am understanding this right you want D to show the
value of A correct. If this is so then change 'D = Evaluate
(A)' to 'D = A'. Also since A is a string you might have
to setup 'A = "1+5+9+7"' like this 'A = Integer
("1+5+9+7")' to get it to do the math. If I am incorrect
in this then a little more explanation of what your
attempting would help. What are you trying to do with this
information? Is this being displayed via a cell, or
through the msgBox?
Ascheman

-----Original Message-----
Sure thing

Sub test()
Dim A As String, D As Double
A = "1+5+9+7"
D = Evaluate(A)
MsgBox D, , A
End Sub

HTH. Best wishes Harald

"Andoni " skrev i
melding
...
If I have a string such as:

a="1+5+9+7"

and I want to use the number, non the string, I mean if
I want to get
the answer=22

a=cdbl(A) does not work!
How can I do this?

PS: I need this!


---
Message posted from http://www.ExcelForum.com/



.