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

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?
 
J

John

Hi Evan
Paste this in "ThisWorkbook" module.
Private Sub Workbook_Open()
userform1.Show
End Sub
HTH
John
 
Top