VBA Invalid Qualifier

H

hendrje

Joined
Jun 18, 2010
Messages
1
Reaction score
0
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: 
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.
 
Back
Top