AutoMacro

Create VBA Code From Scratch

See Pricing

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 that add much needed functionality to the outdated VBA Editor.

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!

automacro

Code Builders

  • Generate VBA code from scratch
  • Visual interfaces "Code Helpers"

Keep Reading...

Code Library

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

Learn More

Coding Tools

  • Tools for Formatting and Navigating
  • Excel Model Debugger & More

Learn More

VBA Code Generators

AutoMacro's VBA code generators build code from scratch via visual interfaces. No coding knowledge required!

Code updates in real-time allowing you to see the impact of your changes.

Loop Builder

Loops and If statements are essential components of VBA programming . With the Loop Builder you can generate conditional loops with a few simple clicks.

Simply select the object (ex. rows) then the action (ex. delete) and last the criteria (ex. blank rows).

You can add additional actions or criteria and "match" the actions to the criteria, allowing you to perform different actions based on which criteria is met.

vba code generator
vba file creator

Files

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

Watch Demo

Message Boxes

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

Watch Demo

vba write messagebox code
inputbox builder

InputBox

Get input from the user with a customizable inputbox.

SelectBox

The SelectBox Builder allows users to select from a list of options.

For example, the SelectBox can list all worksheets, allowing the user to select which sheets to hide, delete, etc.

To accomplish this without AutoMacro you would need to go through the time-consuming process of creating your own UserForm.

selectbox builder
filedialogbox builder

FileDialogBox

Create DialogBoxes to:

  • Pick Files
  • Pick Folders
  • Open Files
  • Save As Files

UserForm Builder

Quickly create UserForms with consistent spacing and pre-generated code.

UserForm design is easily customizable to look more modern than standard UserForm boxes (ex. to match Excel Online formatting).

vba userform builder

Watch Demo

string builder

String Builder

Simple type text and the String Builder will convert the text into a usable VBA string.

Easily insert variables, line breaks, quotations, etc.

Easily apply number formatting.

Arrays

Create Arrays, Collections, and Dictionaries from scratch.

Quick access buttons can be used to quickly insert code for common actions. Learn More

Watch Demo

vba array builder
vba procedure generator

Procedures

Create procedures with desired settings.

Great for beginners who don't know what settings can be used in procedures! Learn More

Watch Demo

Copy Paste

Intuitively build code to copy (or cut) and paste across any worksheet in any open workbook, including paste special operations.

Watch Demo

vba copy paste helper
vba format writer

Formats

Create and preview number formats. Learn More

Watch Demo

Class and Property Builders

Easily create classes and properties - Eliminate repetitive coding.

Watch Demo

vba class builder

Join the Thousands 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

4.6 Average Rating!

See Pricing

Other AutoMacro Features

Code Library

Hundreds of Ready-to-use code examples.

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

Learn More

vba code library builder
vba code tools

Coding Tools

VBA Coding tools to improve the out of date Visual Basic Editor.

Speed up your workflow with tools to navigate, debug, format and more.

Learn More

Why Wait? Order Now

Beginner

1 User - 1 PC
  • Interactive VBA Tutorial
  • 100+ 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
$79.00
One-time fee

Click for Alternative Payment Options

Upgrade Anytime!

Developer

1 User - 3 PCs
  • 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
$159.00
One-time fee

Click for Alternative Payment Options

Upgrade Anytime!

Developer+

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
$149.00
One-time fee + $20 Annual

Click for Alternative Payment Options

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

What is your refund policy?

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!

Can I try AutoMacro before I buy?
Can I install AutoMacro on my Work Computer?

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".

Will AutoMacro work on my system?

AutoMacro is compatible with all versions of Microsoft Office for PCs.

32-bit or 64-bit
Office 2003, 2007, 2010, 2013, 2016, 2019, Office 365, etc.
All Versions of Windows
Surface Pro
AutoMacro is not compatible with Mac operating systems. However, some Mac users running Windows OS are able to use AutoMacro.

If you have doubts, please try the download link above to check.

AutoMacro is not compatible with Citrix environments.

Can I deduct this purchase on my taxes?

See this page from the IRS on Employee Business Expenses.

Can I use on more than one computer?

The Beginner version entitles you to a single-use license code valid for 1 computer. The Developer version is valid for 3 computers. The Developer+ allows you to transfer activations between PCs, so that AutoMacro can be activated on any 3 PCs at one time.

Does AutoMacro work with PowerPoint, Word, or Access?

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

Specific code examples were developed for Excel, Access, Outlook, Word, and PowerPoint.

Visit AutoMacro's FAQ Page

Join the Thousands 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

4.6 Average Rating!

See Pricing

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).