Save Custom Functions from Excel VBA in Add-in Files
Shortcut Keys for Debugging Code in Excel’s Visual Basic Editor
Enable and Trust Macros for Your Excel Dashboards and Reports

How to Edit Macros in Excel's Visual Basic Editor

Click the View Microsoft Excel button at the beginning of the Standard toolbar or click the workbook’s minimized button on the Windows taskbar.

Select an appropriate or safe place in which to test your modified macro and then run it, either by pressing its shortcut keys or by pressing Alt+F8, clicking it in the Macro list box, and then clicking the Run button.

If something doesn’t work as intended or if the macro doesn’t work at all, you need to return to the Visual Basic Editor and find and correct your error(s). Click the Visual Basic command button on the Developer tab of the Ribbon (Alt+LV) to return to the Visual Basic Editor and have a try at editing the code one more time.

If everything checks out and runs as planned, you need to save your changes as outlined in Step 5.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
Use the List Box Control for Your Excel Dashboards
How to Add a Control to Excel Dashboards and Reports
Excel Macros: Shortcut Keys for Navigating the Project Window in Visual Basic Editor
Excel Macros: Shortcut Keys for Working in the Code Window in Visual Basic Editor
Where Is the Visual Basic Editor in Excel 2013?