VBA & Macro Problems

How to Fix Excel VBA Automation Type Errors on Mac

Nimra MalikNimra Malik Nov 4, 2026 869 views

Question details

The user encounters an 'Automation type not supported' error when trying to create a drop-down list using VBA or form controls.

How to Fix Excel VBA Automation Type Errors on Mac
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the Target Cell

Click on the cell or range of cells where you want the drop-down list to appear.

2
Access Data Validation

Navigate to the Data tab on the Excel ribbon and click on the 'Data Validation' button.

3
Configure the Drop-Down List

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.

Use Data Validation to Create a Drop-Down List
Cross-Platform Compatibility: Drop-down lists created via Data Validation work seamlessly across Mac, Windows, and web versions of Excel.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS website to download the free Mac version and complete the lightweight installation.
  2. 2. Open Your Excel File: Launch WPS Spreadsheets and open your existing .xlsx workbooks with perfect formatting retention.
  3. 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.
Free and lightweight spreadsheet softwareHighly compatible with Microsoft Excel file formats (.xlsx, .csv)Built-in easy-to-use Data Validation for error-free drop-down listsFamiliar user interface for a seamless and quick transition
microsoft office alternative - wps office

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.