Auto sum In TextBox

[nidhipatel]

userform contain 10 textbox name is TextBox20 To TextBox 30
i need when enter any value in above 10 TextBox Sum Shown in TextBox 31
i do not click event method i like is selection change event like auto sum
e.g.
when enter value in textbox 1 and enter value in textbox 2 then shown sum in textbox 31

 

[My Aswer Is This]

You will need to use a Textbox exit event not a Textbox change event.
So when you tab out of the textbox the script will run.
Otherwise the second you enter 1 in the texbox the script will run when maybe you were going to enter 12.
The script runs immediately when you enter any value.
Here is what a typical script would need to look like. This script would have to be entered in Textbox's 20 to 30
I know of no way to make this easier for you. But there are a lot of smarter people then me here on Mr. Excel so maybe someone else will have a easier solution which I can also learn

Private Sub TextBox6_Exit(ByVal Cancel As MSForms.ReturnBoolean)
If TextBox31.Value <> "" Then
TextBox31.Value = CDbl(TextBox6.Value) + CDbl(TextBox31.Value)
Else
TextBox31.Value = CDbl(TextBox6.Value)
End If
End Sub