AutoMacro: VBA Code Tools

VBA Coding Tools and Utilities

What is AutoMacro?

AutoMacro is an add-in for VBA that installs directly into the Visual Basic Editor. It comes loaded with code generators, an extensive code library, the ability to create your own code library, and many other time-saving tools and utilities.

AutoMacro does not need to be installed on a computer for the generated code to run. Once the code is generated, anyone can use it!

Excel Automation Tool

Code Builders

  • Generate VBA code from scratch
  • Visual interfaces

Code Library

  • Hundreds of ready-to-use code examples
  • Save your own code

VBA Code Tools

AutoMacro’s Coding Tools and Utilities make coding in VBA easier. Use the tools to navigate, edit, format, and debug your code.

vba formatting tools

Formatting Tools

Tools to format VBA Code:

  • Comment / Uncomment multiple lines
  • Code indenter
  • Remove excess blank lines

Learn More

Navigation Tools

Tools to navigate VBA:

  • Back / Forward Buttons
  • Create bookmarks and goto with shortcut keys
  • Close all windows
  • Close all windows except active

Learn More

vba navigation tools
vba code beautifier

Misc. Utilities

  • Sort code
  • Show line numbers
  • Mass import / export of code modules
  • Copy & Paste UserForm controls & their code

Learn More

Excel / VBA Debug

Excel / VBA Model Debugger:

  • Check for hard-coded ranges in VBA
  • See all procedure contents
  • List named ranges and shapes
  • Find Excel errors.

Learn More

vba debug utility

Join the Hundreds of Professionals Who Use AutoMacro

"AutoMacro is a great tool for saving time when writing code! I use it frequently and love it's compact design with lots of functionality packed in."

Blake - USA

Other AutoMacro Features

Code Library

200+ Ready-to-use code examples.

 

Save your own frequently used code and share with team members.

vba code library builder
vba code builder

Code Generators

Code Generators build code from scratch via visual interfaces.

No coding knowledge required!

Why Wait? Order Now

Beginner

Simple version for beginners

1 User - 1 PC

Interactive VBA Tutorial
100 ready-to-use code examples for Excel
Procedure, Loops, & Copy Paste Builders
All other code generators
Coding tools
Create your own code library
Transfer Activations to other PCs
Access to new features & updates

$79

One-time fee

Upgrade Anytime!

Developer+

Tools for serious developers & more

1 User - 3 Transferable PCs & Updates

Interactive VBA Tutorial
Hundreds of ready-to-use code examples
Procedure, Loops, & Copy Paste Builders
All other code generators
Coding tools
Create your own code library
Transfer activations to other PCs
Access to new features & updates

$169 +

One-time fee + $20 Annual (starts a year from now)

Upgrade Anytime!

companies

AutoMacro has been used by employees of these organizations. These organizations do not endorse, approve, sponsor, or otherwise have any affiliation with this website, Spreadsheet Boot Camp LLC, or ToolFive Software LLC.

FAQ and Other Information

FAQ

No - AutoMacro generates VBA code. Once the code is generated: you can edit the code or copy and paste the code to another document. 

You can send your spreadsheet to anyone else and they will be able to use the generated code. AutoMacro does not need to be installed for the code to run.

We have a 30-day, no-questions-asked, 100% money-back guarantee. If you’re unsatisfied for any reason, let us know and we will refund your order!

Yes! You can download AutoMacro here: https://www.automateexcel.com/automacro/download-walkthrough2. Most of the features are disabled until you enter a License Code, but you can verify that it works properly on your computer. If for some reason it doesn't install properly, let us know: support@toolfivesoftware.com.

Yes! AutoMacro works in many corporate environments. It was designed to be as unobtrusive as possible and should install without the need for "admin privileges".

AutoMacro was designed to work on all Microsoft Windows systems (7,8,10, etc. and 32-bit or 64-bit). It will also work on all versions of Microsoft Office (2007 to present), including 64-bit Microsoft Office.

AutoMacro also works on some Mac setups running Windows OS. However, it will not work on any versions of Excel for Macs.

We recommend installing the trial version to see if your setup is compatible. (Make sure to read the Troubleshooting section of the Download page if you encounter any issues).

Your company may have an allowance that will reimburse you for productivity tools like AutoMacro. This is the case for some of our users. Ask your boss, HR, or IT!

The Beginner version entitles you to a single-use license code valid for 1 computer. The Developer version is valid for 3 computers for which you are the primary user. With the Developer+ version you can transfer activations between computers, allowing AutoMacro to be installed on any 3 computers at one time.

Yes! AutoMacro functions in any program with the Visual Basic Editor.

AutoMacro has specific code examples for Excel, Access, Outlook, Word, and PowerPoint.

Switching Office versions is not a problem.

AutoMacro should continue to work with any new Office versions. Unless you switch bit version (32-bit vs. 64-bit).  If you switch bit versions, simply uninstall AutoMacro, download and install the correct bit version.

Your license will continue to work.

Code Library

Code Tools

AutoMacro's Coding Tools and Utilities make coding in VBA easier.
Use the tools to navigate, edit, format, and debug your code.

Formatting Tools

  • Comment / Uncomment multiple lines
  • Code indenter
  • Remove excess blank lines

Learn More

Navigation Tools

  • Back / Forward Buttons
  • Create bookmarks and goto with shortcut keys
  • Close all windows

Learn More

Debug Excel Model

  • Review all ranges used in VBA. Identify problems.
  • List all procedures, code, and where used.
  • Scan for formula errors
  • & more

Learn More

Misc. Utilities

  • Sort code
  • Show line numbers
  • Mass import / export of code modules
  • Copy & Paste UserForm controls & their code

Learn More

Code Generator

VBA code generators build code from scratch with visual interfaces.
Minimal coding knowledge required.

Loop Builder

Build code to loop through objects, performing actions when certain criteria are met.
Learn More

Array Builder

Create arrays, collections, and dictionaries from scratch and quickly manipulate them..
Learn More

MessageBox Builder 

Create professional looking MessageBoxes and Inputboxes with an easy to use visual interface.
Learn More

Procedure Builder

Create VBA procedures with your desired settings. Great for Beginners who don't know what settings can be used in procedures!
Learn More

File Builder

Generate procedures to loop through files in a folder, performing actions on files that meet certain criteria. Great for merging together multiple files.
Learn More

Format Builder

Quickly create a preview number formats in VBA.
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 - United Kingdom

Steve Rynearson:
Creator of AutoMacro

Over the years, I've spent countless hours searching online for example code and adapting that code to my needs.

I often found myself clicking the same links and copying the same code. I thought there has to be a better way!

AutoMacro eliminates much of this need to search online for code. Instead simply use the menus to select pre-built code or use the builders to generate code for your exact needs.

Additionally, the coding tools will save you time and help you develop more professional looking code.

For anyone coding VBA, AutoMacro is a life-saver. You'll code much faster, develop more professional code, and learn VBA much faster (if you're not already an expert).

steve
signature