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 ge
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

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/

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/



.

I copied the suggested code into a module and ran it. It
does what is requested. I am not sure why, but it works!
Help provides information but not much help on this.

I hope that helps!

Kevin
-----Original 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/



.

.

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/



.

Could you please clarify a little more on how / where you
have this setup. Is the string in the code? Are you
attempting to get the result of the string into a cell?
More information will make it easier to determine what you
are attempting to do, and there by allow for better help.
Ascheman

-----Original Message-----
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/

.