Mac Excel - Combo Box Properties - Where is it?

[Moxioron]

Hello all.

I have Excel 2019 on my iMac and was trying to add a combo box to a validation list. However, I noticed there is no Design button in the Developer tab nor is there a Design Mode option when I right click on the combo box.

There is a Format Control option, that allows me to set the range and such, but where is the Design Mode or the properties that lets me change the name and parameters? Thank you.

 

[MARK858]

As far as I know there isn't a design mode in Mac for Office.
I haven't got a Mac with me to test but perhaps the link below provides a workaround for your situation.

Excel Data Validation Combo box using Named Ranges

Excel data validation using programming and a combo box and named ranges, to allow autocomplete and font formatting.

www.contextures.com

 

[mikerickson]

You need to go to preferences >> Toolbar & Ribbon to make the Developer ribbon visible.
That is where you will find the ComboBox. Note that Mac does not support ActiveX controls and that the controls listed on that ribbon are from the Forms menu only. (No Design mode)

There aren't a whole lot of properties of a Forms Combobox. Source and Cell link are about it. Other than size and location.