Load user form??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)??
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Question about modal userform..... 2
setup.exe 2
Main User form closes when I double Click list box to update 2nd f 3
Open Specific Worksheet Using Button Form Control in Excel 0
Access Access Report Works on One Machine but not Another 3
Run select query from VBA code where criteria comes from a multi select ListBox 2
Multiple users saving a form 3
Access How to calculate the balance carried forward of individual student when payment of fee is made in ms access 2013 1

Back
Top