A couple of question. Does your code compile? (Debug - Compile) Also when
the error occurs what line of code is it stopping on. Finally can you post
your initialize, load, deactivate and terminate code for us to look at.
--
HTH...

Jim Thomlinson


"theguz" wrote:


I am trying to develop a user form, named frmPAFD, in Excel 2000. I try
to write a macro to open the form. It is simple, all I put is:

frmPAFD.Show

I have this in its own macro. However when I try to run it i get the
error:
"Object required" The only way I could get it to open was in its
initialize event. There I input:

frmPAFD.show

It has also worked with:
Load frmPAFD
frmPAFD.Show

But when I try to close it using a button I programed i get the same
error and it jumps to the same line of code in my Macro. The only way
I can view the form is if I do the frmPAFD.Show in the event mentioned
earlier. I have consulted help pages both in excel and on
Microsoft.com as well as other websites. They all say to view the form
just type:

frmPAFD.Show 'In its own Macro.

Am I missing something like a reference or am I doing something wrong?
Please let me know, and thanks for your help.

theguz


--
theguz
------------------------------------------------------------------------
theguz's Profile: http://www.excelforum.com/member.php...o&userid=24918
View this thread: http://www.excelforum.com/showthread...hreadid=384565