Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate the Userform option
I have developed a userform, and I want the UserForm run
autmatically when the excel workbook is opened. What code do I use to make work for me. I would appreciate much any help on matte. Petra W. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate the Userform option
Go to the Visual Basic Editor (Alt+F11).
In the Project Explorer Pane, double-click on the "This Workbook" item. This will open the code window for the workbook and will create a sub like this: Private Sub Workbook_Open() End Sub Between these two lines, add UserForm1.Show (using whatever the name of your form is) So it ends up looking like this: Private Sub Workbook_Open() UserForm1.Show End Sub -- Dianne In , Petra typed: I have developed a userform, and I want the UserForm run autmatically when the excel workbook is opened. What code do I use to make work for me. I would appreciate much any help on matte. Petra W. |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automate the Userform option
Place the following code on the workbook project section
in vb Private Sub_worknook.open() ** your sub** end sub andres -----Original Message----- I have developed a userform, and I want the UserForm run autmatically when the excel workbook is opened. What code do I use to make work for me. I would appreciate much any help on matte. Petra W. . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Dont have secondary axis option listed in Series Option | Charts and Charting in Excel | |||
preserve formatting option in pivot table option dialog box | Excel Discussion (Misc queries) | |||
keep source formatting is not an option in paste option button | Excel Discussion (Misc queries) | |||
Reformat IF(ISERROR(....) : if 1st option returns empty, look at 2nd option. | Excel Worksheet Functions | |||
automate the TAB inside a userform? | Excel Programming |