How to Open an Excel Data Entry Form Automatically at Startup
Question details
The user wants a data entry form to launch automatically as soon as an Excel workbook is opened.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Streamlining data entry workflows by having a dedicated input form pop up immediately upon opening a spreadsheet file.
- Observed behavior
- The built-in Excel data form cannot be configured to remain open as a static page or launch automatically when the workbook opens.
Ensure your workbook is saved in a macro-enabled format (.xlsm) and that you have enabled macros in your Trust Center settings so the VBA startup code is permitted to run.
Use a VBA UserForm to Launch at Startup
Since Excel's built-in data form cannot open automatically, creating a custom VBA UserForm and linking it to a startup event is the most effective workaround.
Excel's built-in data form is designed as a dynamic, on-demand dialog rather than a static page. Because it lacks native startup properties, you must design a custom VBA UserForm. By adding a simple macro to the workbook's open event, you can force this custom form to display the moment the file is opened.
Press Alt + F11 on your keyboard to open the Visual Basic for Applications (VBA) Editor.
Click 'Insert' in the top menu and select 'UserForm'. A blank canvas will appear where you can design your form.
Use the Toolbox to add TextBoxes, Labels, and a CommandButton to your form. Double-click the CommandButton and enter the VBA code to transfer the TextBox values to your worksheet.
In the Project Explorer pane on the left, double-click 'ThisWorkbook'. Paste the following code into the code window: Private Sub Workbook_Open() UserForm1.Show End Sub
Close the VBA Editor. Go to File > Save As, and choose 'Excel Macro-Enabled Workbook (*.xlsm)' from the file format dropdown.

Automate Data Entry with WPS Spreadsheet
WPS Spreadsheet provides robust VBA and macro support, allowing you to easily create, run, and manage custom UserForms that open automatically at startup just like in Microsoft Excel.
- 1. Open your file in WPS Spreadsheet: Launch WPS Office and open your .xlsm macro-enabled workbook.
- 2. Access the Developer Tools: Navigate to the Developer tab on the ribbon and click on 'Visual Basic Editor'.
- 3. Design and Code the Form: Insert a UserForm and add your 'Workbook_Open' trigger in the ThisWorkbook module using the exact same VBA syntax.
- 4. Save and Execute: Save your document. WPS Spreadsheet will seamlessly preserve your macros and automatically launch your data form the next time the file is opened.

Frequently Asked Questions
Why doesn't the default Excel Data Form open automatically?
The built-in Excel Data Form is a system-generated dialog designed to be triggered manually via the Ribbon or Quick Access Toolbar. It does not possess native object properties that allow it to be pinned as a static page or launched via startup events.
What happens if I save a workbook with a UserForm as a standard .xlsx file?
Standard .xlsx files are macro-free formats and cannot contain VBA code. If you save your workbook in this format, all your VBA code, including the UserForm and the startup trigger, will be permanently stripped out. Always save as .xlsm or .xlsb.
How do I hide or close the UserForm after submitting the data?
To dismiss the form after the user clicks the submit button, add the code 'Unload Me' or 'UserForm1.Hide' at the very end of your submit button's click event code.
Can I force a specific worksheet to open on startup instead of a UserForm?
Yes. Instead of using 'UserForm1.Show', you can type 'Sheets("SheetName").Activate' inside the 'Workbook_Open()' event in the ThisWorkbook module to ensure a specific tab is always active when the file opens.




