ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   dim a String A="2+3+5" A=cdbl(A)??? (https://www.excelbanter.com/excel-programming/310152-dim-string-%3D-2-3-5-%3Dcdbl.html)

Andoni[_51_]

dim a String A="2+3+5" A=cdbl(A)???
 
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


Harald Staff

dim a String A="2+3+5" A=cdbl(A)???
 
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/




Ascheman

dim a String A="2+3+5" A=cdbl(A)???
 
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/

.


Ascheman

dim a String A="2+3+5" A=cdbl(A)???
 
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/



.


Kevin

dim a String A="2+3+5" A=cdbl(A)???
 
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/



.

.


Tom Ogilvy

dim a String A="2+3+5" A=cdbl(A)???
 
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/



.





All times are GMT +1. The time now is 10:53 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com