Perhaps you just need a subroutine to do the update. This could then be
called by the On_Change event of the other text boxes.

eg. (pseudo code)

sub UpdateTotalBox()
Textbox10.Value = TextBox1.Value +Textbox2.Value .. etc.
End sub


---
Message posted from http://www.ExcelForum.com/