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.