View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Dmoney Dmoney is offline
external usenet poster
 
Posts: 42
Default Code Does Not Work

Convert the text to an numerical data type such as Decimal
for exmpl:

Dim totl As Variant
totl = CDec(TextBox1.Value) + CDec(TextBox2.Value)

HTH
Devin
-----Original Message-----
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
.