Bring form up automatically

[WSplawn]

Is it possible in Excell 2007 or 2010 to have a form open automatically when opening the spreadsheet? If so, how is this done? I am familiar with VBA but have not used it much in Excel.

[Paul]

Hi WSplawn, welcome to the forum.

You can use the Workbook_Open event to do this. In the VB Editor (ALT+F11) double-click on the ThisWorkbook module and then put the following code in the window to the right:

Please Login or Register  to view this content.

Close the VB Editor and save your workbook. Change "UserForm1" to the name of your user form, of course.