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

How do i load userform automatically?
Pc restarts automatically - Guide
Transfer data from one excel worksheet to another automatically - Guide
Download automatically while roaming - Guide
Unable to load authentication library exiting ✓ - Counter Strike (CS) Forum
No internet load page ✓ - Network Forum

1 response

Answer 1 / 1

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

Similar discussions

Internet connected but webpages won't load

My internet is not working for any of the site except Gmail

Wifi connected but can't open any websites

Have internet connection, browser won't load pages

I can't open my Facebook profile

Similar discussions

Subscribe To Our Newsletter!