You hit it right on the head....many thanks

"Tom Ogilvy" wrote in message
...
In a general modules (if you go to the VBE and do Insert=Module, you will
get a general module).

In this module create a procedure to show the userform

Public Sub ShowMyForm()
Tester.Show
End Sub

now go back to excel and go to Tools=Macro=Macros, select ShowMyForm and
click run.

--
Regards,
Tom Ogilvy

"PCOR" wrote in message
able.rogers.com...
Thanks BUT.....
Lets take this from scratch.
I click on Alt 11
Select INSERTUSERFORM
A user form appears. I can now place controls on the form.
Say I rename the userform to TESTER
Now what I want to know is what do I have to do to get a macro to run
this
TESTER userform
This is all new to me so please be explicit.
Thanks


"David Coleman" wrote in message
...
Hi

As per the help files,

userform1.show

Regards

David


"PCOR" wrote in message
able.rogers.com...
A while back, following written instructions I created a userform
and
a
macro to "SHOW" it
I still remember how to create the userform but have forgotten how
to
get
a
macro to show the userform
Can someone help
Thanks


--
Norton Professional 2004 says this email is clean...believe it