Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
What code do I use to add and load a user form to my excel program? I want it
to load when I open my program in excel. The command buttons are no problem to code. |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In the VBAProject window right-click and do Insert--UserForm. To show the
form when the workbook is opened, double-click the "ThisWorkbook" folder and put UserForm1.Show in the Workbook_Open sub: Private Sub Workbook_Open() UserForm1.Show End Sub "Hammer1947" wrote: What code do I use to add and load a user form to my excel program? I want it to load when I open my program in excel. The command buttons are no problem to code. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2007 displays Locked by "another user", does not show User I | Excel Discussion (Misc queries) | |||
How to: User Form to assign a user defined range to a macro variab | Excel Programming | |||
User Defined Functions - Help Text - Make it Easy for the User | Excel Programming | |||
QUI Expert: Excel-based User Interface or OO User Interface? | Excel Programming | |||
GUI Expert: Excel-based User Interface or OO User Interface? | Excel Programming |