Error 424 - Object Required
 

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?

Error 424 - Object Required
 

Doug,

Try

Load frmPARTS
frmPARTS.Show

HTH,
Bernie
MS Excel MVP

wrote in message
oups.com...

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?

Error 424 - Object Required
 

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