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

See AutoMacro Pricing

Or read my detailed review of AutoMacro

Affiliate Disclosure

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

Keep Reading...

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.

Loops

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

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

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

Copy & Paste

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

Copy or cut; and
Paste.

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.

Files

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

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

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.

Procedures

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

Create procedures with desired settings

Create and preview number formats

Formats

Use the Format Builder to create and preview number formats.

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

See AutoMacro Pricing

Or read my detailed review of AutoMacro

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

Keep Reading...

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.

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.

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.

Files

The Files Code Library contains code for working with:

Files; and
Folders.

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.

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.

See AutoMacro Pricing

Or read my detailed review of AutoMacro

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

Keep Reading...

Coding Tools

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

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

Formatting Tools

AutoMacro contains several VBA code formatting tools:

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

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.

Miscellaneous Utilities

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

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.

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

See AutoMacro Pricing

Or read my detailed review of AutoMacro

Privacy Policy | Affiliate Disclosure | Terms and Conditions | Limit of Liability and Disclaimer of Warranty