Office for Mac Issues

Excel for Mac UserForms Missing from VBA

Maira MehtabMaira Mehtab Nov 12, 2026 869 views

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.
Before you start

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.

Solution 1Recommended

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.

1
Create a worksheet input area

In Excel, add a dedicated worksheet and label cells for each value the form should collect, such as name, date, category, and comments.

2
Add selectable controls with data validation

Select an input cell, open the Data tab, choose Data Validation, select List, and define the allowed values for a drop-down field.

3
Use worksheet controls when available

Open the Developer tab and choose Insert to add supported worksheet controls, such as check boxes, where the workbook requires simple selections.

4
Automate the workflow with Office Scripts

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.

Mac VBA limitation: The UserForm option is intentionally omitted from Excel for Mac. Opening the workbook in Excel for Windows may be necessary to create or edit the original VBA UserForm.
Free Microsoft Office alternative

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. 1. Install WPS Office for Mac: Download and open WPS Office, then launch WPS Spreadsheet from the main app screen.
  2. 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. 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.
Free and lightweight for everyday spreadsheet and form-style worksheet tasksFamiliar spreadsheet interface that supports a smooth migration from ExcelCompatible with Microsoft Excel XLS and XLSX formatsUseful for worksheet-based data entry, tables, formulas, and data validation
QA img-9

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.