Show user form

  • Thread starter Thread starter PCOR
  • Start date Start date
P

PCOR

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
 
Thanks BUT.....
Lets take this from scratch.
I click on Alt 11
Select INSERT>USERFORM
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 said:
Hi

As per the help files,

userform1.show

Regards

David


PCOR said:
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
Click to expand...
get
Click to expand...
 
Hi again

There's not much more to be explicit about I'm afraid - insert a module and
copy the following code in:

sub macro1()
tester.show
end sub

Then when you run it the form will show. However, you probably need to do
much more than just show the form (get user input, prepare output, print,
sort, etc, etc) but without much more detail I can't offer a great deal
more...

Regards

David




PCOR said:
Thanks BUT.....
Lets take this from scratch.
I click on Alt 11
Select INSERT>USERFORM
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
Click to expand...
 
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 said:
Thanks BUT.....
Lets take this from scratch.
I click on Alt 11
Select INSERT>USERFORM
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
Click to expand...
 
You hit it right on the head....many thanks

Tom Ogilvy said:
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

and
Click to expand...
 
Back
Top