ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Load user form?? (https://www.excelbanter.com/excel-programming/398817-load-user-form.html)

Mekinnik

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)??

FSt1

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)??



All times are GMT +1. The time now is 09:42 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com