Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load user form??
Is it possible and if it is can get some assistance in making a user form
load when the application starts so that the user has to click the appropriate button control to start the application (i.e. enter company info and products, list reports for various units, and print reports)?? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Load user form??
hi,
a workbook open event ought to do it Private Sub Workbook_Open() Load frmYourForm frmYourForm.Show 0 AppActivate Application.Caption End Sub Put this in the thisworkbook module. change yourform to your form name. Regards FSt1 "Mekinnik" wrote: Is it possible and if it is can get some assistance in making a user form load when the application starts so that the user has to click the appropriate button control to start the application (i.e. enter company info and products, list reports for various units, and print reports)?? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
User Form - how to load it | Excel Discussion (Misc queries) | |||
How can I load a user form from within a worksheet subroutine? | Excel Programming | |||
How can I load a user form from within a worksheet subroutine? | Excel Programming | |||
how to load chart in user form | Excel Programming | |||
Userform doesn't recognize other user form upon re-load | Excel Programming |