How to Fix Excel VBA Automation Type Errors on Mac
Question details
The user encounters an 'Automation type not supported' error when trying to create a drop-down list using VBA or form controls.

- Product
- Microsoft Excel
- Device & OS
- Mac
- Scenario
- Creating a drop-down list using VBA macros or inserting form controls in a worksheet on a Mac device.
- Observed behavior
- Excel displays a 'Variable uses an Automation type not supported in Visual Basic' error because some Windows-only ActiveX controls or specific automation objects are not compatible with macOS.
Ensure the Developer tab is enabled in your Excel ribbon, as you will need it to access Mac-compatible form controls and the built-in macro recorder.
Use Data Validation to Create a Drop-Down List
The most reliable and natively supported way to create a drop-down menu in Excel for Mac without triggering VBA automation errors.
Instead of using complex VBA scripts or unsupported ActiveX controls, the built-in Data Validation feature is fully compatible across all Excel versions.
Click on the cell or range of cells where you want the drop-down list to appear.
Navigate to the Data tab on the Excel ribbon and click on the 'Data Validation' button.
In the Allow drop-down menu, select 'List'. In the Source box, enter your list items separated by commas or select a cell range containing your items, then click OK.

Insert a Standard Worksheet ComboBox Control
If you specifically need a form control on your worksheet, use the built-in Mac-compatible ComboBox instead of ActiveX controls.
Generate Compatible VBA Code Using the Macro Recorder
Ensure your VBA code relies only on Mac-supported libraries by letting Excel generate the baseline code automatically.
Try WPS Office for Seamless Spreadsheet Management on Mac
If you frequently encounter VBA automation errors and compatibility issues in Excel for Mac, consider switching to WPS Office. It provides a lightweight, free alternative with high compatibility for Microsoft Office formats, a familiar user interface, and seamless migration.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free Mac version and complete the lightweight installation.
- 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx workbooks with perfect formatting retention.
- 3. Create Drop-Downs Easily: Use the built-in Data Validation tools found in the Data tab to create functional drop-down lists without coding.

Frequently Asked Questions
Why do I get an 'Automation type not supported' error in Excel for Mac?
This error occurs because certain automation objects, ActiveX controls, and specific UserForm properties are designed exclusively for the Windows operating system and lack support in the macOS environment.
Does Excel for Mac actually support VBA macros?
Yes, Excel for Mac fully supports standard Visual Basic for Applications (VBA). However, any VBA scripts that attempt to call Windows-only system libraries (like ActiveX) will result in compilation or runtime errors.
How can I create a drop-down list on Mac without using VBA?
The easiest and most universally compatible method is using the Data Validation feature. Select a cell, go to the Data tab, click Data Validation, choose 'List', and define your items.




