Thread: Text Boxes
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Jamal[_2_] Jamal[_2_] is offline
external usenet poster
 
Posts: 15
Default 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
.