Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Greetings,
I am trying to add two numbers together but I can't get it to give the right answer. Where T8 = $100.00 and T9 = $ 8.00. Both T8 and T9 are TextBoxes as is T10. Here are a couple of the variations of code that I tried: T10.Text = Val(T8.Text) + Val(T9.Text) returns 0 T10.Text = Val(T8.Text) + T9.Text returns 8 T10.Text = T8.Text + Val(T9.Text) returns 100 T10.Text = T8.Text + T9.Text T10.Text = T8.Value + T9.Text T10.Text = T8.Text + T9.Value T10.Text = T8.Value + T9.Value Each returns $ 100.00$ 8.00 Does anyone see what is wrong? Any help would be appreciated. TIA -Minitman |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Why does this code not work? | Excel Discussion (Misc queries) | |||
Help getting code to work. | Excel Programming | |||
Why my code do not work : - ( | Excel Programming | |||
Why my code do not work : - ( | Excel Programming | |||
Why my code do not work : - ( | Excel Programming |