Save Custom Functions from Excel VBA in Add-in Files
How to Edit Macros in Excel's Visual Basic Editor
Use the Check Box Control for Your Excel Dashboards

Use the Button Control for Your Excel Dashboards and Reports

Excel offers a set of controls called Form controls, designed specifically for adding user interface elements to your dashboards and reports. After you place a Form control on a worksheet, you can then configure it to perform a specific task.

The Button control gives your audience a clear and easy way to execute the macros you’ve recorded. To insert and configure a Button control, follow these steps:

  1. Click the Insert drop-down list under the Developer tab.

  2. Select the Button Form control.

  3. Click the location in your spreadsheet where you want to place your button.

    The Assign Macro dialog box appears and asks you to assign a macro to this button, as shown in this figure.

  4. Edit the text shown on the button by right-clicking the button, highlighting the existing text, and then overwriting it with your own.

    To assign a different macro to the button, simply right-click and select Assign Macro to reactivate the Assign Macro dialog box, as shown in the previous figure.

    When you add macros to a workbook, you’ll have to save that workbook as an .xlsm file in order to share your macros with others. If you save the workbook as a standard .xlsx file, Excel will strip your macros out of the workbook.

blog comments powered by Disqus
Enable and Trust Macros for Your Excel Dashboards and Reports
How to Assign Macros to the Ribbon and the Quick Access Toolbar in Excel 2013
Excel Dashboards and Reports: How to Run Your Macros
How to Record New Macros in Excel 2013
How to Add Dialog Boxes to Excel Macros with Visual Basic Editor