Initializing Userform

[Szadkowski]

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

 

[Tom Ogilvy]

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