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?
 
Doug,

Try

Load frmPARTS
frmPARTS.Show

HTH,
Bernie
MS Excel MVP
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Run-Time Error '424': Object required when Saving Document 6
424 object required for object ReportItem 0
Object Required 2
Error 424 : Object required 3
Object required error 424 why getting? 2
Run Time Error on trying to save workbook 14
Excel VBA Classes Error: 424 Object Required 2
Object Required error 1

Back
Top