I have textbox1 and textboxchange.
I have code which says:

Cells(1,2).value=textbox1 - textboxchange

This works fine, however this doesnt:
Cells(2,2).value=textbox1 + textboxchange

I simply get the value of textbox1 eg 23 plus the value of textbox change on
the end eg. if txtboxchange=3 the the result is 231.
I'm completly stumped by this. Thanks
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is enough!"

The + is concatenating the two values since the default
data type for a textbox is a string. You need to cast the
textbox value to a number. Try this...

Cells(2, 2).Value = CLng(textbox1) + CLng(textboxchange)
-----Original Message-----
I have textbox1 and textboxchange.
I have code which says:

Cells(1,2).value=textbox1 - textboxchange

This works fine, however this doesnt:
Cells(2,2).value=textbox1 + textboxchange

I simply get the value of textbox1 eg 23 plus the value
of textbox change on
the end eg. if txtboxchange=3 the the result is 231.
I'm completly stumped by this. Thanks
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is
enough!"


.

As Melanie said...use CDbl rather than CLng
-----Original Message-----
The + is concatenating the two values since the default
data type for a textbox is a string. You need to cast
the
textbox value to a number. Try this...

Cells(2, 2).Value = CLng(textbox1) + CLng(textboxchange)
-----Original Message-----
I have textbox1 and textboxchange.
I have code which says:

Cells(1,2).value=textbox1 - textboxchange

This works fine, however this doesnt:
Cells(2,2).value=textbox1 + textboxchange

I simply get the value of textbox1 eg 23 plus the value
of textbox change on
the end eg. if txtboxchange=3 the the result is 231.
I'm completly stumped by this. Thanks
--
Cheers,
Ben

Remove your.tonsils to reply
"You only live once but if you do it right once is
enough!"


.

.

Hi Ben,

Ben Allen wrote:
I have textbox1 and textboxchange.
I have code which says:

Cells(1,2).value=textbox1 - textboxchange

This works fine, however this doesnt:
Cells(2,2).value=textbox1 + textboxchange

I simply get the value of textbox1 eg 23 plus the value of textbox change on
the end eg. if txtboxchange=3 the the result is 231.
I'm completly stumped by this. Thanks

the values of the textbox are in the string format.
For calculation they must be converted with the
CDbl Function into numeric values.

Cells(1, 2).Value = CDbl(textbox1 ) - CDbl(textboxchange)
Cells(2, 2).Value = CDbl(textbox1 ) + CDbl(textboxchange)

--
Mit freundlichen Grüssen

Melanie Breden
- Microsoft MVP für Excel -

http://excel.codebooks.de (Das Excel-VBA Codebook)