Previous Topic Next Topic

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 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
2

Similar discussions

Internet connected but webpages won't load
Sarah86 -
AS -

32 responses
Counter Strike unable to load authentication libra
0250 -
bilstein -

16 responses
Required Solution for Unable to load authentication library
Ahmed -
HelpiOS -

1 response
COUNTER STRIKE FATAL ERROR
stranger -
tony -

8 responses
Why does our account keep randomly following additional users every few weeks?
Coach -
ElenaKM -

1 response