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?

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?

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