VBA & Macro Problems

Fix Excel for Mac Cannot Display or Edit VBA UserForm

Nimra MalikNimra Malik Nov 3, 2026 871 views

Question details

The user is unable to view, create, or edit VBA UserForms using the Visual Basic Editor in Excel for Mac.

How to Fix Excel for Mac Cannot Display or Edit VBA UserForms
Product
Microsoft Excel for Mac (2016, 2019)
Device & OS
macOS
Scenario
Attempting to design or modify a graphical VBA UserForm within the Visual Basic Editor on an Apple Mac computer.
Observed behavior
The Visual Basic Editor successfully opens and displays the macro code, but the graphical UserForm designer is missing, preventing any visual edits or replacements.
Before you start

Verify exactly which version of Office for Mac you are using (e.g., 2016, 2019, or Office 365) and ensure your macro-enabled workbooks (.xlsm) are saved before transferring them between operating systems.

Solution 1Recommended

Use Excel for Windows to Edit the UserForm

Since Excel for Mac 2016 and 2019 do not support the visual UserForm designer, the most reliable workaround is to perform your design edits on a Windows machine.

Office for Mac 2016 and 2019 lack the necessary built-in modules to create or visually modify VBA UserForms. While macros will often still run correctly on a Mac, structural or UI modifications to the forms themselves must be completed on a fully supported version, such as Excel for Windows.

1
Transfer Your File

Copy your macro-enabled workbook (.xlsm) to a Windows computer that has Microsoft Excel installed.

2
Open Visual Basic Editor on Windows

Open the file in Excel for Windows and press the 'ALT + F11' shortcut keys to launch the Visual Basic Editor.

3
Edit the UserForm

Locate your UserForm in the Project Explorer panel, double-click it to open the graphical designer, and make your necessary layout changes.

4
Save and Return to Mac

Save the workbook, close Excel for Windows, and transfer the file back to your Mac. The updated UserForm will now execute successfully on your macOS device.

Use Excel for Windows to Edit the UserForm
Avoid ActiveX Controls: When designing your UserForm on Windows, refrain from adding ActiveX controls. These are exclusive to the Windows environment and will cause your macros to fail when run on a Mac.
Free Microsoft Office alternative

Switch to WPS Office for a Seamless Spreadsheet Experience

If you are frustrated by platform-specific limitations and feature restrictions in Microsoft Office, consider switching to WPS Office. It provides a lightweight, highly compatible, and free alternative with a familiar interface that makes migrating your spreadsheets effortless.

  1. 1. Download the Application: Visit the official WPS Office website and download the installation package for your specific operating system (Windows or Mac).
  2. 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
  3. 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks directly to enjoy a fast, compatible editing experience.
Fully compatible with Microsoft Excel formats, including .xlsx, .xls, and macro-enabled filesFamiliar user interface for a zero-learning-curve transition from ExcelLightweight architecture that runs smoothly on both Windows and Mac operating systemsBuilt-in advanced spreadsheet and data analysis features at no additional cost
microsoft office alternative - wps office

Frequently Asked Questions

Will purchasing an Office 365 subscription fix the missing UserForm designer on Mac?

No. Subscribing to Office 365 does not add UserForm design support to Office for Mac 2016 or 2019. This is a fundamental limitation built into the software architecture of these specific Mac versions, regardless of your subscription tier.

Why does my VBA UserForm show only code instead of the visual designer on my Mac?

Excel for Mac versions 2016 and 2019 do not include the visual designer module for VBA UserForms. They possess the capability to read and execute the underlying code, which is why the Visual Basic Editor displays only the text script instead of the visual layout.

Can I still run my existing VBA UserForms on Excel for Mac?

Yes. As long as the UserForms were created correctly (typically on a Windows machine) and do not contain Windows-exclusive features such as ActiveX controls, your existing VBA macros and UserForms will generally run and function normally on Excel for Mac.