How do i load userform automatically?

Closed
marcstrong - Aug 11, 2009 at 02:10 PM
Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 - Aug 12, 2009 at 01:41 AM
Hello,

is there a way to load a userform everytime i open an excel file?

currently i have a spreadsheet where a command button must be clicked

Private Sub CommandButton1_Click()
ShowForm
End Sub

however, i would like the userform to load automatically in place of the spreadsheet when the file is opened

1 reply

Excelguru Posts 261 Registration date Saturday April 11, 2009 Status Member Last seen June 21, 2011 307
Aug 12, 2009 at 01:41 AM
put a command to laod a userform in a sub auto_open() in a module
2