5 TextBox in userfomr name is TextBox1 To TextBox5 i wish enter any value in 5 TextBox then sum is show in TextBox8. do not use command button click event but do this change event. e.g. enter any value update the sum
delta... do not use ... do this ...
Would You try this way?
Do to each TextBoxN Sub like below Ps. This WON'T check, do You write numbers to those Textboxes!
Code:
Private Sub TextBox1_Change()
TextBox8.Value = Val(TextBox1.Value) + Val(TextBox2.Value) + Val(TextBox3.Value) + Val(TextBox4.Value) + Val(TextBox5.Value)
End Sub