How do I use the formula for "SUM" in a textbox on a UserFor

[34sweetness]

I have a UserForm that will be used to input inspection data, with a textbox for the Qty Inspected, then several other textboxes to input the number of rejected parts (each textbox for the rejects corresponds to a specific reject code). I then want to have a textbox that will show the sum of the ‘rejects’, meaning I want to add up the total number of rejects. How can I do this, so that the Qty Rejected textbox is ‘automatically’ updated while the data is being input into the ‘reject/code’ textboxes?

 

[Andrew Poulsom]

You need to add up the values in your text boxes. Say TextBox1 to TextBox3 are your data entry text boxes and TextBox4 is your total text box:

Private Sub TextBox1_AfterUpdate()
   TextBox4.Value = TextBox1.Value + TextBox2.Value + TextBox3.Value
End Sub

and repeat for TextBox2 and TextBox3.

 

[34sweetness]

On 2002-10-14 12:36, Andrew Poulsom wrote:
You need to add up the values in your text boxes. Say TextBox1 to TextBox3 are your data entry text boxes and TextBox4 is your total text box:

Private Sub TextBox1_AfterUpdate()
   TextBox4.Value = TextBox1.Value + TextBox2.Value + TextBox3.Value
End Sub

and repeat for TextBox2 and TextBox3.

I did what you stated above, however, this only added the "strings" together. I am entering numbers, and want the total "number" of rejects 'summed up' on the form.

 

[Andrew Poulsom]

Sorry, I forgot that quirk:

TextBox4.Value = Val(TextBox1.Value) + Val(TextBox2.Value) + Val(TextBox3.Value)

 

[34sweetness]

On 2002-10-14 14:15, Andrew Poulsom wrote:
Sorry, I forgot that quirk:

TextBox4.Value = Val(TextBox1.Value) + Val(TextBox2.Value) + Val(TextBox3.Value)

Thanks, that works now. Excellent!