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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to transfer the data from userform to spreadsheet for specific dates 0
Excel Excel 2007 fails on insert userform 0
Frame control scroll bar 0
UserForm 1
Excel How to Fix Damaged Excel File That Won't Open? 3
Excel How to capture data to a specified excel sheet(first workbook) of two different workbooks from the 0
disabling macro 2
Excel Displaying content from excel sheet onto textbox in userform 0

Top