I am having an Error 424 error - Object required.

I get a 424 error on the frmPARTS.show line.

Private Sub cmdFindPN_Click()

frmPARTS.Show
Set frmPARTS = Nothing

End Sub

However, that userform DOES exist in the workbook with that name; I
havent changed the workbook (but our network did hiccup a little when I
was saving it; access to the "My Documents" directory was severed
during the save operation. I have exported the form, saved the XLS
without the offending form, reimported the file, to no avail...

Ideas?