userforms

[Donald]

I created a very simple userform. How do I activate it on the sheet?

 

[technix]

On 2002-08-30 20:09, Donald wrote:
I created a very simple userform. How do I activate it on the sheet?

There is a couple different ways you can have it open when to workbook opens or initiate it with macros or commandbuttons

What is your goal?

Derrick

 

[white6174]

or when you click print
(thats what i use it for)

steve w

 

[Joe Was]

In a Sub in a sheet module or standard module:

TheUserFormNameHere.Show

like:

UserForm1.Show

Then run the sub. JSW

 

[Donald]

[No message]

 

[Donald]

I want to choose when to activate the useform, such as through a button.

The userform will have a series of print option buttons that the enduser will be able to choose from.

thanks for the assistance

 

[GeorgeB]

Donald
In the VBE click on Insert.
Click on Module
Click back on Insert
Click on Procedure
Give it a name (No spaces)
Between the name and End Sub type in:
UserForm1.Show (Or if you have changed the name)
Name.Show
Back to the sheet from the Forms toolbar click on the button icon.
Click on the sheet where you want to put it.
Highlight the macro you want to attach it to.
Click off the button.
Right click the button and click on Edit Text
Rename the button
Voila

 

[stevebausch]

To be placed in ThisWorkbook:


Private Sub Workbook_BeforePrint(Cancel As Boolean)
VerySimpleUserform.Show
End Sub