ActiveX is solely the Windows option, Mac OS doesn't support it. Download excel for mac. How to add a checkbox in Excel. To insert a checkbox in Excel, do the following: On the Developer tab, in the Controls group, click Insert, and select Check Box under Form Controls or ActiveX Controls. Show the thousands separator: Select the Thousands Separator checkbox. Use accounting-style negative numbers: Select the Accounting Style checkbox to display negative values within parentheses. Click the Currency pop-up menu, then choose a currency symbol, such as US Dollar ($). ![]() There are lots of ways to do this in Excel. As was already suggested, you can use the Data Validation feature's List capability to make a pop-up menu from which to choose a list from a cell range. Another way is to make a combo box: Or a list box Or make a form on a dialog sheet Or make a control on a VBA UserForm that using standard (not Active-X) controls. I am an unpaid volunteer and do not work for Microsoft.
'Independent Advisors' work for contractors hired by Microsoft. 'Microsoft Agents' work for Microsoft Support.
0 Comments
Leave a Reply. |