ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Load a Userform (https://www.excelbanter.com/excel-programming/276599-load-userform.html)

Nick

Load a Userform
 
How do I program Excel so that I can automatically load a
userform upon opening a workbook?

nathan

Load a Userform
 

-----Original Message-----
How do I program Excel so that I can automatically load a
userform upon opening a workbook?
.
In the vb screen under this workbook, select

workbook_open then put in userform1.show, which will load
and show, or just load userform1 to load it, then when
ever you need it userform1.show.

Hope this helps.

Nath.


All times are GMT +1. The time now is 08:32 AM.

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