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.

To make a command button perform an action, you write a macro or event procedure and attach it to the command button's On Click property. You can also embed a macro directly into the On …

Add favorite commands to the Quick Access Toolbar to quickly use them in your Office apps.

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, …

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 …

Double-click a function name to display the function and its arguments in the Function Arguments wizard, which helps you add correct arguments. Help on this function

You can insert a button, sometimes referred to as a command button or push button, on a Microsoft Office InfoPath form template. Users click buttons to initiate an immediate action, …

Oct 14, 2025 · In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK. To edit the ActiveX control, make …

Excel has two types of controls: Form controls and ActiveX Controls. In addition to these sets of controls, you can also add objects from the Drawing tools, such as a AutoShapes, WordArt, …

On the ribbon, select the appropriate tab or group to display the command that you want to add to the Quick Access Toolbar. Right-click the command, and then select Add to Quick Access …