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
--
Regards,
Tom Ogilvy
"Steve Lerner" wrote in message
...
-----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)