In the sections below, learn how to add a macro to a button in Excel—for Windows or the Mac. Note: ActiveX controls are not supported on the Mac.

You can assign a macro to a button on the Quick Access Toolbar or to a button in your own personal group on the ribbon. If you want a macro button to be available in other workbooks, assign it to a …

To add a combo box, click the Developer tab, click Insert, and then click Combo Box under Form Controls. Click the worksheet location where you want the upper-left corner of the combo box to …

This procedure creates a button in the workbook that runs the script when the button is selected. It also shares the script with anyone who can edit the workbook.

To use a value from the form for the button text, click Insert Formula . In the Insert Formula dialog box, click Insert Field or Group, and then select the field or group that you want to use.

You can insert form controls such as check boxes or option buttons to make data entry easier. Check boxes work well for forms with multiple options. Option buttons are better when your user has just …

Add a scroll bar or spin button to an Excel worksheet. The controls let you quickly enter or change a range of values.

When you work with these controls, Excel displays the message Cannot insert object if you try to add them to a worksheet. You will need to enable the Developer tab on the ribbon before you can work …

You can insert form controls like check boxes, option, or toggle buttons to make data entry easier.

Slicers provide buttons that you can click to filter tables, or PivotTables. In addition to quick filtering, slicers also indicate the current filtering state, which makes it easy to understand what exactly is …