Make 2015 totally awesome. Take the Dummies challenge and you could win $1,000! Learn how.
Save Custom Functions from Excel VBA in Add-in Files
How to Find Form Controls for Excel Dashboards and Reports
Use the List Box Control for Your Excel Dashboards

How to Edit Macros in Excel's Visual Basic Editor

Edit the statements in the Code window of the Visual Basic Editor as needed.

After you finish editing the macro, you’re ready to return to your spreadsheet, where you can test out the modified macro and make sure that you haven’t added some wacky, unwanted command to the macro or, even worse, crippled it so that it no longer runs at all.

  • Add a Comment
  • Print
  • Share

Recommends

Promoted Stories From Around The Web

blog comments powered by Disqus
Enable and Trust Macros for Your Excel Dashboards and Reports
Use the Button Control for Your Excel Dashboards and Reports
How to Record New Macros in Excel 2013
Excel Dashboards and Reports: How to Run Your Macros
How to Add a Control to Excel Dashboards and Reports
Advertisement

Inside Dummies.com