How do you make a userform open automatically when you open excel?

  • Thread starter Thread starter Evan
  • Start date Start date
E

Evan

I created a Userform in VBA, and want it to automatically appear upon opening
the Excel file everytime. How do I do that?
 
Hi Evan
Paste this in "ThisWorkbook" module.
Private Sub Workbook_Open()
userform1.Show
End Sub
HTH
John
 
Back
Top