Excel for Mac UserForms Missing from VBA
Question details
The user needs to understand why the UserForm option is missing from the Visual Basic Editor in Excel for Mac and what alternatives are available.
- Product
- Microsoft 365 Excel for Mac VBA
- Device & OS
- macOS, including Apple silicon Macs
- Scenario
- The user opens the Visual Basic Editor in Excel for Mac and wants to create or edit a VBA UserForm.
- Observed behavior
- The UserForm option is omitted from the Insert menu, although Module and Class Module options may still be available.
Check whether the workbook depends on a UserForm created in Excel for Windows and identify the input fields or controls the form needs. Keep a copy of the workbook before replacing the form with worksheet-based controls or another solution.
Replace the VBA UserForm with a supported form approach
Use this approach when the workbook must remain usable on a Mac without relying on the unsupported UserForm editor.
Excel for Mac does not support creating or editing VBA UserForms in the Visual Basic Editor. A UserForm created on Windows may also be unavailable or only partially supported on Mac.
For simple data-entry workflows, worksheet cells, data validation lists, and form controls can provide a practical replacement. More automated workflows may use Office Scripts or a third-party form service.
In Excel, add a dedicated worksheet and label cells for each value the form should collect, such as name, date, category, and comments.
Select an input cell, open the Data tab, choose Data Validation, select List, and define the allowed values for a drop-down field.
Open the Developer tab and choose Insert to add supported worksheet controls, such as check boxes, where the workbook requires simple selections.
Open the Automate tab and choose New Script to create a script that validates the worksheet entries, processes the data, or moves submissions to another sheet.
Use WPS Office for Mac for Lightweight Spreadsheet Workflows
WPS Office provides a free, lightweight spreadsheet alternative with a familiar interface and strong Microsoft Excel file compatibility. It can help you migrate worksheet-based forms, data-entry layouts, and everyday spreadsheet tasks when Excel for Mac does not provide the VBA UserForm feature. WPS Office does not restore Microsoft VBA UserForms, so Windows Excel remains necessary for editing those original forms.
- 1. Install WPS Office for Mac: Download and open WPS Office, then launch WPS Spreadsheet from the main app screen.
- 2. Open the Excel workbook: Choose Open from the WPS Spreadsheet home screen and select the XLS or XLSX workbook you want to use.
- 3. Rebuild the worksheet form: Create labeled input cells and use the Data tab's validation tools to reproduce drop-downs and other worksheet-based form elements.

Frequently Asked Questions
Why is UserForm missing from Excel for Mac?
Microsoft Excel for Mac does not support creating or editing VBA UserForms in the Visual Basic Editor, so UserForm is omitted from the Insert menu.
Can I edit a Windows-created Excel UserForm on a Mac?
A UserForm created in Excel for Windows may not be editable or fully supported in Excel for Mac. Use Windows Excel to maintain the original form or replace it with a worksheet-based workflow.
Are VBA modules still available in Excel for Mac?
Yes. Module and Class Module options may remain available in the Visual Basic Editor, but their availability does not mean that UserForms are supported.
What can I use instead of an Excel VBA UserForm on Mac?
Use worksheet input cells with Data Validation lists, supported Developer tab controls, Office Scripts from the Automate tab, or a third-party form solution.
Can WPS Office create or edit Microsoft Excel VBA UserForms?
No. WPS Office does not restore Microsoft VBA UserForm editing. It is an alternative for compatible worksheet-based spreadsheet tasks, while Excel for Windows is needed for the original VBA UserForm workflow.




