I'm trying to create a simple total displayed in a label. Basically, I
have twelve entries for price and quantity. I'm trying to have a label
(label 23 below) show the total as the user fills in the data.

The total label works if all price and quantity fields are filled.

Private Sub q7_Exit(ByVal Cancel As MSForms.ReturnBoolean)

On Error Resume Next
Label19 = q7 * price7

On Error Resume Next
Label23 = ((price1 * q1) + (price2 * q2) + (price3 * q3) + (price4 *
q4) + (price5 * q5) + (price6 * q6) + (price7 * q7) + (price8 * q8) +
(price9 * q9) + (price10 * q10) + (price11 * q11) + (price12 * q12))

End Sub


Thanks