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

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

Yes the code does compile, I don't get the error untill I open it o
close the form. Here is the macro that opens the form:

Sub frmPAFD_Activate()
'This macro opens the user form

frmPAFD.Show '*Here is where error always occurs*

End Sub

And here is the initialize event code:

Private Sub UserForm_Initialize()
'Initialize the form properties when opened


frmPAFD.Show '*With out this line I can't even preview the form.*
optbutton1 = False
optButton2 = False
Accttxt.Value = ""
P_Stxt.Value = ""
titletxt.Value = ""

'Variable for "for" loop
Dim i As Integer

i = 1

'Loop for initalizing all those txt boxes with almost same name
For i = 1 To 24
TextBoxi.Value = ""
Next i

Accttxt.SetFocus

End Sub

I haven't added code to the load, deactivate and terminate events yet.
I have been to frustrated to continue. Thanks you very much for th
reply. Other forums haven't given me a response yet.
thegu

--
thegu
-----------------------------------------------------------------------
theguz's Profile: http://www.excelforum.com/member.php...fo&userid=2491
View this thread: http://www.excelforum.com/showthread.php?threadid=38456

i may be wrong but if i remember correctly, your code should be in th
UserForm_Activate event not frmPADF_Activate. this should be in th
code for that form so excel recognizes which form it's for

--
tkapla
-----------------------------------------------------------------------
tkaplan's Profile: http://www.excelforum.com/member.php...fo&userid=2298
View this thread: http://www.excelforum.com/showthread.php?threadid=38456