Calculation error

[ellyna]

Hi, when i submit the user form into excel sheet, the column on "Production Output and Total Rejection" do not show the value

Dropbox - File Deleted - Simplify your life

www.dropbox.com

1)"Production Output and Total Rejection" do not show the value .

2)The output that on multipage summary is below , but it does not calculate the total percentage . As i just do the first one and the result do not showed calculate of percentage.

Private Sub TextBox3_Change()
      TextBox4.Value = IIf(Val(txtTextBox5) > 0, Val(TextBox5.Value) / Val(TextBox3.Value), "0.00%")
End Sub


Private Sub TextBox2_Change()
    TextBox6.Value = IIf(Val(txtTextBox2) > 0, Val(TextBox5.Value) / Val(TextBox2.Value), "0.00%")
End Sub

Private Sub TextBox5_Change()
    TextBox8.Value = IIf(Val(txtTextBox5) > 0, Val(TextBox7.Value) / Val(TextBox5.Value), "0.00%")
    
End Sub

 

[ellyna]

2.For ProductionOutput & Total Rejection at Packing tab you define at other textbox change event equal to ....
you should change it at all to textbox number at summary sheet with If condition Based Machine name.

And Are your Total Material(A) at Summary sheet equal to ProductionOutput at Packing sheet. if Not are input that manual.

If you dont mind can tou change at my code ? because i have no idea on how to edit my script as i'm new and try and error of my script.

As for this question below i prefer tokey in manually. Just need to do calculation on the percentage and i have problem on inserting into the excel sheet for packing and summary as some of the value do not inserted.
And Are your Total Material(A) at Summary sheet equal to ProductionOutput at Packing sheet. if Not are input that manual.