Combo box in Excel 2011 for Mac

albert_sun

New Member
Joined
Aug 5, 2013
Messages
1
Hi,

I had a macro-enabled spreadsheet works well in windows PC, and now I want to make it work on Mac. When I open the spreadsheet in excel 2011 on mac, I noticed the following problems for combo boxes.

1). In windows version, when you click on a drop down list, the content will show, and then you can click to select from the drop down list, but in Mac version, when you click on the drop down list, you have to hold to select from the list. Is this something related with the keyboard settings? I am using the mac track pad, not trying the mouse yet.

2). When there are more than one drop down list contained in one page, choosing from one drop down list will make other drop down lists invisible, but other drop down list still there. When you click the field of one of other drop down list, it will bring back all the lists. How to avoid this problem?

Thanks.
 

Excel Facts

Fastest way to copy a worksheet?
Hold down the Ctrl key while dragging tab for Sheet1 to the right. Excel will make a copy of the worksheet.

Forum statistics

Threads
1,217,476
Messages
6,136,883
Members
450,029
Latest member
MissQuotation

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top