Assign a macro to a Form or a Control button - Microsoft Support
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.
Assign a macro to a button - Microsoft Support
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 …
Create a button to run an Office Script - Microsoft Support
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.
How to use the forms controls on a worksheet in Excel
Microsoft Excel provides several controls for dialog sheets that are useful for selecting items from a list. Examples of controls are list boxes, combo boxes, spin buttons, and scroll bars.
Add a scroll bar or spin button to a worksheet - Microsoft Support
Add a scroll bar or spin button to an Excel worksheet. The controls let you quickly enter or change a range of values.
Use slicers to filter data - Microsoft Support
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 …
Using check boxes in Excel - Microsoft Support
Check boxes are a versatile feature in Excel, useful for making interactive lists and forms. In this article, we'll cover how to add, remove, and toggle them. Insert check boxes Select the range where you …
Overview of forms, Form controls, and ActiveX controls on a worksheet
There are several types of forms that you can create in Excel: data forms, worksheets that contain Form and ActiveX controls, and VBA UserForms. You can use each type of form by itself, or you can …
Form controls - Microsoft Support
Currently, you can't use check box controls in Excel for the web. If you're working in Excel for the web and you open a workbook that has check boxes or other controls (objects), you can't edit the …
Create a named range from selected cells in an Excel worksheet
Select Formulas > Create from Selection. In the Create Names from Selection dialog box, select the checkbox (es) depending on the location of your row/column header.