ellyna
Banned - Rules violations
- Joined
- Nov 29, 2020
- Messages
- 89
- Office Version
- 2013
- Platform
- Windows
Hi, when i submit the user form into excel sheet, the column on "Production Output and Total Rejection" do not show the value
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.
Dropbox
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.
VBA Code:
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