Text Boxes
Hi Dennis,
T1.value+t2.value concatenate the result. I have tried
with text and value. Same result. Anyway, thanks for your
interest and suggestion. Cheers.
-----Original Message-----
The contents of a textbox is just that, text. So when you
write Total.ext =
TextBox1.text + TextBox2.text + TextBox3.text, Excel
believes you are asking
for concatenation, just like "Apple" + "Pie" = "Apple
Pie".
What you should be doing to get an arithmetic sum is
writing Total.Value=
TextBox1.Value+TextBox2.Value+TextBox3.Value
-- Dennis Eisen
.
|