Fix Excel for Mac Cannot Display or Edit VBA UserForm
Question details
The user is unable to view, create, or edit VBA UserForms using the Visual Basic Editor in Excel for Mac.

- 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.
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.
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.
Copy your macro-enabled workbook (.xlsm) to a Windows computer that has Microsoft Excel installed.
Open the file in Excel for Windows and press the 'ALT + F11' shortcut keys to launch the Visual Basic Editor.
Locate your UserForm in the Project Explorer panel, double-click it to open the graphical designer, and make your necessary layout changes.
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 an Older Compatible Version of Office for Mac
If you do not have access to a Windows PC, an older version of Excel for Mac (like Office 2011) that retained UserForm design support can be used as a bridge.
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. Download the Application: Visit the official WPS Office website and download the installation package for your specific operating system (Windows or Mac).
- 2. Install WPS Office: Run the installer and follow the on-screen instructions to set up WPS Office on your computer.
- 3. Open Your Spreadsheets: Launch WPS Spreadsheets and open your existing Excel workbooks directly to enjoy a fast, compatible editing experience.

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.




