Please help with my runtime error '424' object required

[ashley12]

Here is my code:

Private Sub Worksheet_Change(ByVal Target As Range)
    If Target.Address = "$E$70" Then
        If Me.Range("E70") = "Yes" Then
            If Me.Range("E9") = "" Then
                MsgBox "Please enter school ID at the start of the form to continue"
                Me.Range("E70") = ""
            Else
                Personnel_form.Show
            End If
        End If
     End If
End sub

The debuger pointed at "Personnel_form.Show". It's to show my userform.

Would appreciate your help. Thanks

 

[AlphaFrog]

The error is basically saying it cannot locate your user form. Is it spelled correctly? Is it in the same wordbook as the code?

 

[ashley12]

The error is basically saying it cannot locate your user form. Is it spelled correctly? Is it in the same wordbook as the code?

Hi AlhaFrog. Yes, that was the first thing I thought of. I copied and paste the name of the form so make sure the spelling correct (as screenshot below). I tried switching the name with other forms and it works. I'm not sure what else can go wrong.

 

[AlphaFrog]

As a test, can you run Personnel_form manually without error?

 

[ashley12]

As a test, can you run Personnel_form manually without error?

Oh I never thought of doing that. No it doesn't run. It shows the same error, as if the form didn't exist. But it's right there. Do you know what might have happened?

 

[AlphaFrog]

Something in your user form code in preventing it from initializing. Put breakpoints in the code and see if you can locate it.

 

[ashley12]

Thank you so much. I found it. Turns out I changed name of some ComboBoxes without doing the same for form initialization part