Overview of the VBA Editor, Reading VBA Code, and Eliminating Waste

mtgingrass

2017/08/31

[embed]https://youtu.be/GNulOwQT0mk[/embed]

Overview of the VBA Editor, Reading VBA Code, and Eliminating Waste

First, a quick overview of how to record and run macros. Then the tutorial shows the user how to manually check the VBA code for a particular macro. How to change module names and macro names. Also a few key terms such as Integrated Development Environment (IDE).

A few key takeaways form this tutorial.

  1. Open the VBA Editor

  2. Rename Modules

  3. Edit Modules and Sub/End Sub

  4. How to add comments to the code

  5. How to read the code - sort of

  6. How to auto-fit columns using VBA

  7. Saving macro enabled workbooks

comments powered by Disqus