How do I automatically open a UserForm in Excel?

In order to open a UserForm automatically, you will need to use the “open”
event of the Excel workbook.

Here is the code to add to the “ThisWorkbook” object’s Open event:

After you save and close the workbook, and then reopen it, the UserForm will automatically appear.

PS. Make sure you save the workbook as an xlsm (macro enabled workbook), because you do have VBA code in it (which is considered a macro)!

Let me know if you have questions.

Please remember to subscribe to my youtube channel

Been helped? Get these!