ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Initializing Userform (https://www.excelbanter.com/excel-programming/308453-initializing-userform.html)

Szadkowski

Initializing Userform
 
I have a userform and i was wondering how to initialize it so it pops up when
the user loads the workbook..

Tom Ogilvy

Initializing Userform
 
see Chip Pearson's page on events

http://www.cpearson.com/excel/events.htm

You would use the Workbook_Open event which would be placed in the
thisworkbook module.

by the way, this is showing the userform.

Private Sub workbook_Open()
userform1.show
End Sub

--
Regards,
Tom Ogilvy


"Szadkowski" wrote in message
...
I have a userform and i was wondering how to initialize it so it pops up

when
the user loads the workbook..





All times are GMT +1. The time now is 12:06 PM.

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