Error 424 - Object Required

  • Thread starter Thread starter doug
  • Start date Start date
D

doug

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?
 
Turns out when I forgot I made a modification to the userform, and it
was choking on the userform initialize event (I changed the name on a
textbox).

However, I have had this problem before, and I will keep this fix in
mind...

Thx
 
Back
Top