Skylark_za,

I think you should try using this code instead...

Sub EnterData()
frmPartLoc.Show
End Sub

I have never had to use "frmPartLoc.Show FALSE" to get a user form to
show...not even sure what the FALSE part even does for that
matter...hope that works.

-Todd

skylark_za wrote:
Please could somebody tell me how I would create a control to run the
userform that I have created for an Excel spreadsheet (Excel 2002).

I have tried using
frmFormName.Show False

but this gives me the following debug message
Sub EnterData()
- frmPartLoc.Show False
End Sub

Any insight as to what I may be doing wrong will be appreciated.

Thanks

Hi Jim and Tom

Thanks for your inputs into my problem. Are you able to send me an email
address so that I can send screen dumps to show you my errors as I have
posted the debug errors in my previous postings and think if I am able to
show my debug errors it may be easier for you diagnose my problem.

Thanks

Jason


"Jim Thomlinson" wrote:

Additionally you should confirm that your code compiles. Debug - Compile
--
HTH...

Jim Thomlinson


"Tom Ogilvy" wrote:

in the vbe, go into tools=Options and under the general tab, change Break on
Unhandled errors to Break in Class Module.

It appears you have an error in the code associated with your userform.
This should allow Excel to highlight the error in that code.


--
Regards,
Tom Ogilvy



"skylark_za" wrote:

I have tried both the following codes o two PCs now, one running Office XP
(2002) and the other Office 2003. I want to call the userform from a Macro.
This is the only code in the Macro and so I am not sure if I am missing
anything.

Sub EnterData() (this line is highlighted yellow in debug)
frmprospects.Show (with and without False)
End Sub

and

Sub InsertData() (this line is highlighted yellow in debug)
frmprospects.Show (with and without False)
End Sub


and the errror I am receiving is:
Compile Error.
"Method or Data member not found"

frmprospects is the name of my userform, so am I calling the correct thing
in the Macro above?

Any ideas what I may still be doing wrong.