VBA Tools & Utilities for Excel Developers

AutoMacro: VBA Tools & Utilities for Excel VBA Code Developers

What is AutoMacro?

AutoMacro is a collection of VBA tools that installs directly into the Visual Basic Editor:

VBA Tools and Utilities
  • Generate VBA Code From Scratch
  • Loops Builder, Array Builder, MessageBox Builder, File Processing Wizard, Procedure Builder, and Format Builder
  • Save You Own Code
  • Use one of our 200+ ready-to-use code fragments
  • VBA coding tools to help you work faster

...or keep reading below

​VBA Development Tools

Tools to Clean Code:

  • AutoIndent
  • Remove Excess Linebreaks
  • Comment Code
  • Sort Module Contents

Navigation:

  • Back and Forward Buttons
  • Add/Remove Bookmarks and Navigate Between

Development Tools:

  • Import / Export Multiple Code Modules
  • Copy Userform Controls and Paste Corresponding Code
  • Save Frequently Used Code for Easy Access
  • Debug Excel VBA models

Tools to Clean Code

VBA Code Cleaner

Code Indenter

Quickly apply "best-practice" VBA code indentation to an entire module at once. Run the auto-indenter on any code module with poorly formatted code.

Remove Excess Line Breaks

This feature removes excess line breaks. Use this in conjunction with the Code Indenter to quickly clean your code format, making it consistent and easy to read.

Insert Image

CTRL + ALT + C

Insert Image

Comment or Uncomment Multiple Lines of Code at Once

Insert Image

CTRL + ALT + C

Insert Image

Easily Comment or Uncomment out multiple lines of code at once. Use the keyboard shortcut CTRL + ALT + C, the icon in the command bar, or the right-click menu.

AutoMacro is smart enough to understand when only part of a highlighted section is commented

Sort Code

Sort procedures within a module. You no longer need to copy and paste procedures to move them around, instead use the sort feature to re-arrange your code.

sort vba code utility

Tools to Navigate

Bookmarks

Easily "bookmark" code and navigate between bookmarks with keyboard shortcuts.

Insert Image

CTRL + ALT + C

Insert Image

Back and Forward Buttons

Insert Image

CTRL + ALT + C

Insert Image

Back button navigates to previous code positions.

Development Tools

Bulk Import / Export Code Modules

Now easily bulk import or export modules and userforms.

Insert Image

CTRL + ALT + C

Insert Image

Copy Userform Controls

Insert Image

CTRL + ALT + C

Insert Image

AutoMacro provides the ability to copy and paste Userform controls (and the corresponding VBA code)  from one Userform to another.

Save Frequently Used Code Fragments

AutoMacro comes pre-loaded with 200+ ready-to-use code fragments. Simply navigate to the desired menu, click the code fragment and its insert directly into the active code module.

You can also save your own code to the Custom Code folder. You can organize this folder with subfolders, keyboard shortcuts, and even share the code fragments with colleagues.

Insert Image

CTRL + ALT + C

Insert Image

Debug Excel Models

vba debug tool

The Debug tool analyzes an Excel model and creates a report, identifying potential errors:

  • List all Excel named ranges. Are there any duplicate worksheet vs workbook-level names?
  • Scan VBA for all used ranges. Are any ranges hard-coded? Do all named ranges exist?
  • List all used procedures. Where are the procedures called (other procedures, shapes, etc.)?
  • Are there any formulas with errors? How many volatile functions are used