AutoMacro
VBA Add-In: Coding Tools, VBA Code Examples, and VBA Code Generators

What is AutoMacro?

AutoMacro:

  • Is an add-in for VBA.
  • Installs directly into the Visual Basic Editor (VBE).


Depending on the version, AutoMacro comes loaded with the following tools/features:

  • Code generators;
  • An extensive code library;
  • The ability to create your own code library; and
  • Advanced coding tools.

Code Generators

Code Library

Coding Tools

  • Generate VBA code from scratch via visual interfaces
  • Requires none/minimal VBA coding knowledge
  • Massive time-savers for experienced programmers
  • Hundreds of ready-to-use code examples
  • Quickly/easily insert commonly-used code examples
  • Create your own custom code library
  • Improve the Visual Basic Editor
  • Make coding in VBA easier
  • Formatting and navigation tools
  • Excel/VBA Model Debugger

VBA Code Generators

AutoMacro's VBA Code Generators:

  • Build code from scratch via visual interfaces;
  • Require none or minimal VBA coding knowledge; and
  • Are massive time-savers for more experienced programmers.

Learn More

Loops

Use the Loop Builder to build VBA code that does the following:

  1. Loops through objects/items.
  2. Performs actions with/on some/all of those objects/items.

Learn More

Build VBA code that loops through objects/items.
Create Message and Input Boxes

Message and Input Boxes

Easily create good looking professional:

  • Message Boxes; and
  • Input Boxes 

Learn More

Copy & Paste

Use the Copy & Paste Builder to build VBA code that does the following:

  1. Copy or cut; and
  2. Paste.

Learn More

Build code to copy or cut and paste across any worksheet
Create arrays, collections and dictionaries from scratch

Arrays

Use the Array Builder to create, and work with:

  • Arrays;
  • Dictionaries; and
  • Collections.

Learn More

Files

Use the File Processing Wizard to build VBA code that does the following:

  1. Loops through all files in a folder.
  2. Performs actions with/on some/all of those files.


Learn More

Build VBA code to work with all files in a folder
Create classes and properties

Classes and Properties

Use the Class and Property Builder to create:

  • Classes; and
  • Properties.

Learn More

Procedures

Use the Procedure Builder to create procedures with certain specific/desired settings.


Learn More

Create procedures with desired settings
Create and preview number formats

Formats

Use the Format Builder to create and preview number formats.


Learn More

Join the Hundreds of Professionals Who Use AutoMacro

"I use it almost every day. A great tool for getting things done, but also a great tool for learning how to do things! This is one purchase this year I have no regrets about."

Galen - USA

Code Generators

Code Library

Coding Tools

  • Generate VBA code from scratch via visual interfaces
  • Requires none/minimal VBA coding knowledge
  • Massive time-savers for experienced programmers
  • Hundreds of ready-to-use code examples
  • Quickly/easily insert commonly-used code examples
  • Create your own custom code library
  • Improve the Visual Basic Editor
  • Make coding in VBA easier
  • Formatting and navigation tools
  • Excel/VBA Model Debugger

Code Library

AutoMacro's Code Library contains hundreds of commonly-used code examples:

  • The Beginner version contains 100 ready-to-use code examples.
  • The Developer and Developer+ versions contain 230+ ready-to-use code examples.

You can insert these code fragments into your VBA code with:

  • The click of a button; or
  • Keyboard shortcuts.

Simply select the code from AutoMacro's menu and it will be inserted directly into your module.


Learn More

AutoMacro's Code Library contains commonly-used code fragments

Object Code Library

AutoMacro's Object Code Library allows you to:

  • Interact with the objects that compose the Excel Application; and
  • Learn about the hierarchy in which the objects that compose the Excel Application are organized.

Learn More

Ranges drop-down
The Settings library contains the most common Excel/VBA settings

Settings

Use the Settings Code Library to work with several commonly-used settings, including the following:

  • Screen updating, which allows you to control whether screen updating is turned on or off.
  • Automatic calculations, which allows you to specify Excel's calculation mode (for example, automatic or manual).
  • Events, which allows you to disable events.
  • Error handling, which allows you to specify how potential run-time errors are handled.

Learn More

Files

The Files Code Library contains code for working with:

  • Files; and
  • Folders.

Learn More

Code library for working with files and folders
Create your own VBA code library

Custom Code Library

With AutoMacro's Developer and Developer+ versions, you can do the following:

  • Create your own Custom Code Library.
  • Organize your code into folders.
  • Access your custom code via:
    • User-created menus; or
    • Keyboard shortcuts.
  • Share your custom code with friends and colleagues.

Learn More

Join the Hundreds of Professionals Who Use AutoMacro

"I have only just scratched the surface of what's doable AutoMacro, and already I'm blown away! This is definitely money well spent for anyone who works with VBA regularly."

Jody L.

Code Generators

Code Library

Coding Tools

  • Generate VBA code from scratch via visual interfaces
  • Requires none/minimal VBA coding knowledge
  • Massive time-savers for experienced programmers
  • Hundreds of ready-to-use code examples
  • Quickly/easily insert commonly-used code examples
  • Create your own custom code library
  • Improve the Visual Basic Editor
  • Make coding in VBA easier
  • Formatting and navigation tools
  • Excel/VBA Model Debugger

Coding Tools

AutoMacro's (Developer and Developer+ versions) Coding Tools:

  • Improve the Visual Basic Editor (VBE); and
  • Make coding in VBA easier.

Learn More

Formatting Tools

AutoMacro contains several VBA code formatting tools:

  • Comment/uncomment multiple lines of code.
  • Auto-Indent.
  • Remove excess line-breaks.

Learn More

Tools to format VBA code
Tools to navigate VBA code

Navigation Tools

AutoMacro contains several tools to help you quickly/easily navigate VBA Projects:

  • Back and Forward buttons.
  • Bookmarks.
  • Close all windows.

Learn More

Miscellaneous Utilities

  • Display line numbers.
  • Sort code.
  • Mass import/export of modules.
  • Copy UserForm controls and code.

Learn More

Sort code, show line numbers, import/export modules, copy/paste UserForm controls/code
Debug Tool makes reviewing Excel models easier

Excel/VBA Model Debugger

Review/debug Excel/VBA models with the help of the following 5 reports:

  • Excel Named Ranges Report.
  • VBA Range Report.
  • Shape Procedures Report.
  • Procedures List Report.
  • Formula Error Report.

Learn More

Join the Hundreds of Professionals Who Use AutoMacro

"Great product, haven’t stopped using it since I purchased it. It doesn’t just write your code, it teaches as you go!"

Tony D - UK

Cookies help us deliver our services. By continuing to use our site, you agree to our use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close