Add values of textboxes together

  • Thread starter Thread starter Candee
  • Start date Start date
C

Candee

Hello all

I have a userform that has 5 text boxes on it (Textbox1, Textbox2
etc.) where a user will enter a number in the first 4 boxes. What
would like to happen is in Textbox5 to add the entered numbers from th
first 4 boxes together to give me a total, which will then b
transferred to a spreadsheet(I have that part figured out, just nee
help with the addition part).

Thanks in advance...
 
Candee,

Try something like the following code:

Dim Total As Double
With Me
With .TextBox1
If IsNumeric(.Text) Then
Total = Total + CDbl(.Text)
End If
End With
With .TextBox2
If IsNumeric(.Text) Then
Total = Total + CDbl(.Text)
End If
End With
With .TextBox3
If IsNumeric(.Text) Then
Total = Total + CDbl(.Text)
End If
End With
With .TextBox4
If IsNumeric(.Text) Then
Total = Total + CDbl(.Text)
End If
End With
.TextBox5.Text = Format(Total, "#,##0.00")

Range("A1").Value = Total
End With



--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



Candee said:
Hello all

I have a userform that has 5 text boxes on it (Textbox1, Textbox2,
etc.) where a user will enter a number in the first 4 boxes. What I
would like to happen is in Textbox5 to add the entered numbers from the
first 4 boxes together to give me a total, which will then be
transferred to a spreadsheet(I have that part figured out, just need
help with the addition part).

Thanks in advance....


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step guide
Click to expand...
to creating financial statements
 
Candee,

TextBox values are stored as strings.
You need to convert them to actual values before doing any math
with them.

e.g.

TBSum = Val(TextBox1.Value) + Val(TextBox2.Value) + Val(TextBox3.Value)
MsgBox TBSum

John
 
-----Original Message-----

Hello all

I have a userform that has 5 text boxes on it (Textbox1, Textbox2,
etc.) where a user will enter a number in the first 4 boxes. What I
would like to happen is in Textbox5 to add the entered numbers from the
first 4 boxes together to give me a total, which will then be
transferred to a spreadsheet(I have that part figured out, just need
help with the addition part).

Thanks in advance....


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by
Click to expand...
step guide to creating financial statements
.
Click to expand...
Added a Linked Cell range to TextBox1-TextBox4 (e.g., A1,
A2, A3, A4). Then add a Linked Cell range to TextBox5
(e.g. A5) that contains the formula =sum(A1:A4)
 
Did that work for you? It doesn't work for me. (numbers in the linked cells
are stored as Text so they are ignored by SUM.)

Also, if someone typed in the results textbox (by mistake), it would
overwrite the formula.

xl2000, Windows 2000
 
Back
Top