MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Form load


Posted by Cory on June 15, 2001 2:37 PM

Stupid question time...
How do i get a form to load when I open a workbook?


Posted by Cory on June 15, 2001 2:40 PM

Oh yeah: Where do I put the code? General Declarations?

Posted by steve w on June 15, 2001 3:35 PM


In the workbook module use this code.


Private Sub Workbook_Open()
UserForm1.Show
End Sub
Hope this helps steve w