Hi,
I'm trying to call a userform (code for this one found below) from another userform. The first one works similarly to this one--different variables, but same structure--and runs fine, but I receive an "Invalid Qualifier" error when this one runs for every variable (if I comment the first one out it will do it to the second one, etc).
Is there something wrong with calling a private sub from a private sub, or is something else going on?
PHP Code:
Private Sub CMA_FL_EABS_RR_BPR_Update_Click()
Dim Cavity_Number As Integer
Dim Wet_Weight As Double
Dim Dry_Weight As Double
Dim one50_1 As Double
Dim one50_2 As Double
Dim one50_3 As Double
Dim three50_1 As Double
Dim three50_2 As Double
Dim three50_3 As Double
Cavity_Numbery = Cavity_Number.Value
Wet_Weighty = Wet_Weight.Value
Dry_Weighty = Dry_Weight.Value
One50_1y = one50_1.Value
One50_2y = one50_2.Value
One50_3y = one50_3.Value
Three50_1y = three50_1.Value
Three50_2y = three50_2.Value
Three50_3y = three50_3.Value
Cells(lastrow - 1 + i, 51).Value = Cavity_Numbery
Cells(lastrow - 1 + i, 52).Value = Wet_Weighty
Cells(lastrow - 1 + i, 53).Value = Dry_Weighty
Cells(lastrow - 1 + i, 54).Value = One50_1y
Cells(lastrow - 1 + i, 55).Value = One50_2y
Cells(lastrow - 1 + i, 56).Value = One50_3y
Cells(lastrow - 1 + i, 57).Value = Three50_1y
Cells(lastrow - 1 + i, 58).Value = Three50_2y
Cells(lastrow - 1 + i, 59).Value = Three50_3y
End Sub
Thank you.
Similar Threads
