G Guest Aug 31, 2004 #1 I have a userform and i was wondering how to initialize it so it pops up when the user loads the workbook..
I have a userform and i was wondering how to initialize it so it pops up when the user loads the workbook..
T Tom Ogilvy Aug 31, 2004 #2 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
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
