| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How do I get User Form to run at start up?
When I start my Excel file I have to choose tools/macros/visual basic editor and the open Userform1 and choose to run it. How can I make my file user friendly for my co-workers by having them open my file and instantly have the UserForm appear? -- Bafa ------------------------------------------------------------------------ Bafa's Profile: http://www.excelforum.com/member.php...o&userid=37748 View this thread: http://www.excelforum.com/showthread...hreadid=573686 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I get User Form to run at start up?
Hi
In the Editor project explorer window double click the ThisWorkbook module. In the dropdown on the top left where it says (General), choose the Workbook option. The shell of the Workbook_Open macro should appear. Now simply put Userform1.Show in this sub and the userform will show when you open the workbook. regards Paul Bafa wrote: When I start my Excel file I have to choose tools/macros/visual basic editor and the open Userform1 and choose to run it. How can I make my file user friendly for my co-workers by having them open my file and instantly have the UserForm appear? -- Bafa ------------------------------------------------------------------------ Bafa's Profile: http://www.excelforum.com/member.php...o&userid=37748 View this thread: http://www.excelforum.com/showthread...hreadid=573686 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
How do I get User Form to run at start up?
In the code module for ThisWorkbook:
Private Sub Workbook_Open() UserForm1.Show End Sub Mike F "Bafa" wrote in message ... When I start my Excel file I have to choose tools/macros/visual basic editor and the open Userform1 and choose to run it. How can I make my file user friendly for my co-workers by having them open my file and instantly have the UserForm appear? -- Bafa ------------------------------------------------------------------------ Bafa's Profile: http://www.excelforum.com/member.php...o&userid=37748 View this thread: http://www.excelforum.com/showthread...hreadid=573686 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Place a User Form on Start Up | Excel Programming | |||
| User form with looping doesn't start at right place. | Excel Programming | |||
| How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
| I am looking to see if anybody has an equivalant user form to Outlooks CONTACT form | Excel Programming | |||
![Bafa[_15_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
