Thread: Text Boxes
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jamal[_2_] Jamal[_2_] is offline
external usenet poster
 
Posts: 15
Default Text Boxes

I was following a question, which was posted to this group
about two weeks ago on summing up the values of text boxes
into another text box. I tried the following:

TextboxTotal = T1+T2+T3 'T being the textboxes

instead of adding the numerical values it just places them
side by side. So the contents of Textboxtotal becomes
100200300 instead of 600. However when i did the following
it works:

TextboxTotal = (T1*1)+(T2*1)+(T3*1)

it seems the contents of each box is not being treated as
numbers.

I am using Excel 2000

Is this a bug or I am missing something? Thanks. It is
just bugging me.