I am using Excel for Mac 16.3. I have created a combo box but I cannot figure out how to get to design view or see the combo box properties so that I can make modifications. Help!
Excel VBA Course - From Beginner to Expert
200+ Video Lessons
50+ Hours of Video
200+ Excel Guides
Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)
EXCEL FOR MAC V 16.3 COMBO BOX
0
Discussion
There are several kinds of combo boxes. A validation list is still something else. Your question is far too imprecise to be able to answer. Please amend it. Edit the question itself. Don't write any explanations in the Discussion. Consider attaching your workbook.
Variatus (rep: 4889) Jun 14, '20 at 9:16 pm
Answers
0
Selected Answer
Assuming that you want your combo box on a worksheet, you probably already have the Developer tab on your ribbon. If you don't read up on how to display the Developer tab in the ribbon.
In about the center of the ribbon there are two menu buttons, side by side. One is called Insert, the other Design Mode. Click the first one. In the selection box that opens there are two rows of controls, Form Controls and ActiveX controls. Select the combo box from among the latter.
When you create the combo box the Design Mode button is highlighted automatically because you are in design mode then and should remain so until your combo box is ready for action. The Design Mode button is a toggle. Presss it again to exit design mode. In design mode the combo box has no functionality but you can edit it.
While in design mode, right-click on the combo box. One of the items on the context menu that opens is called Properties. This is the button that opens the properties window.
Discussion
Thank you for your response. I am using the MAC version of Excel. The Developer tab does have a Combo box button but there is very little I can do to modify it I ce it's created. There is no Form control for MAC now and Design View is only visible in the VBA Editor. Maybe the MAC version just can't do much. I want to see more than one column in my Combo box drop down list and change the font size. Any other suggestions would be appreciated.
TWHEARD (rep: 4) Jun 15, '20 at 9:14 pm
Placing the Design button on the VB Editor is probably a good idea. But then I would presume that the properties appear in the VBE's property pane, perhaps with a switch, to show either the VB-related properties or those of the Shape. Look for such a switch in the properties pane control.
Meanwhile I came across this page. It's for Excel 2011 and all posts on the blog are ancient but it's dedicated to Excel for Mac. I imagine if you could find a more recent version by the same author the forum there should be better suited to answer your question. Good luck!
Meanwhile I came across this page. It's for Excel 2011 and all posts on the blog are ancient but it's dedicated to Excel for Mac. I imagine if you could find a more recent version by the same author the forum there should be better suited to answer your question. Good luck!
Variatus (rep: 4889) Jun 16, '20 at 8:03 pm