MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Object required error (Excel VBA)


Posted by Geoff on January 21, 2002 2:57 PM

I have been working on a UserForm in Excel. I had been using Office '97 but then I upgraded to Office 2000. I recently made some modifications to the UserForm and now when I run the lines:

Load frm3PassWiz2
frm3PassWiz2.Show

I receive an error:

Runtime error '424':

Object required

It actually happens on the line frm3PassWiz2.Show. So it manages to load the form, but when I go to show it, it needs an object? I don't quite understand. If anyone can help, I would be very grateful.

Thanks in advance,

Geoff


Posted by Damon Ostrander on January 21, 2002 11:35 PM

Hi Geoff,

Unfortunately, this is where Excel always stops when you get this type of error inside your userform code. Most likely the error is in your userform's Initialize event, assuming you are using it. I suggest setting a breakpoint at the beginning of the Initialize code and single-step from there to determine where the error is occurring. If it then isn't obvious what the problem is, post that code here and let us look at it.

Regards.

Damon