Thread: How do you make a userform open automatically when you open excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John[_22_] John[_22_] is offline
external usenet poster
  
Posts: 694
Default 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?

Reply With QuoteReply With Quote