-----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....
------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from
http://www.ExcelForum.com/
~~Now Available: Financial Statements.xls, a step by
step guide to creating financial statements
.
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)