Values in textbox are read as strings so I can't add them, how do i solve this?

[kjy1989]

I have no idea why excel vba is doing this.

Please Login or Register  to view this content.

So the textbox sum is supposed to add the amount in textbox_body and the amount in textbox_components. But that doesn't happen, instead, excel puts them together and treats it as a string. For example textbox_body has a value of 2.5 and textbox_components is 2.7, instead of getting 5.2 it returns 2.52.7 !!

I also tried

Please Login or Register  to view this content.

and

Please Login or Register  to view this content.

but none of those worked.

it may be important to note that the values textbox_body and textbox_components are extracted from an excel sheet like so:

Please Login or Register  to view this content.

What am i doing wrong here?

[:) Sixthsense :)]

May be try this....

Please Login or Register  to view this content.

[hemesh]

Don't Know much but Try keeping

Please Login or Register  to view this content.

[Izandol]

It is better to coerce to numeric:

Please Login or Register  to view this content.

[kjy1989]

It is better to coerce to numeric:

Please Login or Register  to view this content.

thank you to all that replied, I tried everything but the only one that worked was yours Izandol, thank you. However i still have a problem with it.

If either textbox_body or textbox_components has no value in it, it returns an error called Run time error 13: Type Mismatch.

I know that's causing the problem because when i put 0 in the empty textbox, it works, but if it's empty. it doesnt, how do i solve this?

[Izandol]

You may use Val instead of CDbl or you may test:

Please Login or Register  to view this content.