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

I created a Userform in VBA, and want it to automatically appear upon opening
the Excel file everytime. How do I do that?

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

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