VBA & Macro Problems

Troubleshoot an Excel for Mac Drop-Down That Opens but Cannot Select Options

Jason MillerJason Miller Nov 13, 2026 869 views

Question details

The user needs to select an option from a form-control drop-down in Excel 365 for Mac without moving the control.

Product
Microsoft Excel 365 for Mac
Device & OS
Mac; macOS version not provided
Scenario
Using a worksheet form-control drop-down, including a combo box with an assigned macro.
Observed behavior
The drop-down displays its options, but clicking an option moves the control instead of selecting it. The issue also occurs in a new workbook, and restarting the Mac did not help.
Before you start

Open Excel > About Microsoft Excel and record the version and build number. Identify whether the affected object is a worksheet form control, and note its assigned macro, input range, and linked cell before changing its configuration.

Solution 1Recommended

Exit control-editing or object-selection states

Use this check first when clicking the drop-down moves or selects the control instead of choosing a list item.

1
Return to normal worksheet interaction

Press Esc to dismiss any active menu or object selection, then click an ordinary worksheet cell. If an object-selection tool is active in your Excel interface, turn it off before testing the control.

2
Open the list without selecting the object

Click the drop-down arrow normally, without holding Control or using a secondary click. Click a visible option and check whether it is selected or whether sizing handles appear around the control.

3
Inspect the control settings separately

Control-click the control border and choose Format Control. On the Control tab, review the Input range and Cell link, then close the dialog, click a worksheet cell, and test the drop-down again.

Design Mode is not a standard Mac troubleshooting step: Windows instructions for ActiveX controls and Developer > Design Mode do not generally apply to worksheet form controls in Excel for Mac. Excel for Mac does not support worksheet ActiveX controls.
Free Microsoft Office alternative

Use WPS Spreadsheet for Everyday Excel Workbook Editing

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface and support for Excel formats, making it easy to move everyday workbook editing tasks. It does not repair Excel for Mac form-control behavior; verify any VBA or form-control requirements before migrating a control-dependent workbook.

Open and edit Microsoft Excel .xlsx and .xls files.Use a familiar spreadsheet interface for everyday workbook tasks.Use in-cell drop-down lists for simple option selection where supported, rather than relying on macro-assigned controls.Move routine spreadsheet work to a free, lightweight Office suite.
QA img-9

Frequently Asked Questions

Why does clicking an Excel drop-down move the control instead of selecting an option?

The click may be selecting or editing the object rather than interacting with its list. Press Esc, click a normal worksheet cell, and then click the drop-down arrow normally. If it still moves, test a fresh form-control combo box without an assigned macro to narrow down the cause.

Should I turn off Design Mode in Excel for Mac?

Design Mode advice usually concerns Windows ActiveX controls. Excel for Mac does not support worksheet ActiveX controls. For a Mac form control, first exit object selection with Esc and test a normal click on the drop-down arrow.

What should the linked cell show when a form-control combo box works?

A form-control combo box's linked cell normally contains the selected item's position, such as 1 for the first item, rather than the item's text. Control-click the control, choose Format Control, and inspect Cell link on the Control tab.

What information should I provide if the problem also happens in a new workbook?

Provide the Excel version from Excel > About Microsoft Excel, the macOS version, exact reproduction steps, input range, linked cell, and any assigned macro code. Also state whether a newly inserted combo box with no assigned macro fails, since that is more informative than testing another macro-assigned control.