VBA Tools for Developers
Buy Now
A Registered Affiliate
See Pricing
The Ultimate VBA Tools Add-in
Whether you’ve never written a line of VBA code or you’re an experienced programmer, AutoMacro has tools to help you be more productive in Excel VBA.
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.
VBA Tools for Everyone
AutoMacro was designed to be the ultimate productivity enhancing tool for VBA.
It’s an add-in that installs directly into the VBA Editor:
Code Builders
Quickly generate code from scratch using simple-to-use visual interfaces
Code Library
Hundreds of professionally developed VBA code examples inserted into your code module with just a mouse click. Or create your own code library!
Coding Tools
VBA coding tools to help you create better code, faster!
See PricingCustom Code Library
AutoMacro’s most popular feature!
The Custom Code Library allows you to save frequently used code for future use.
Organize your code into folders.
Share with colleagues or with multiple PCs.
VBA Code Library
AutoMacro also contains hundreds of built-in VBA code fragments, procedures and functions, organized in easily accessible menus directly in the VBE. Add your own code to the code library with the Custom Code feature!
Quick Reference Code
Workbooks, Worksheets, Ranges, Columns & Rows
Tables
Arrays
Settings
Date & Time
Text
Files
MessageBoxes
Loops and Fors
Ifs and Cases
Full Procedures and Functions
Worksheets
Workbooks
Loops and Fors
Identify Cells
Functions
Columns & Rows
Events
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
See our
on
Average Rating!
See Pricing
VBA Code Generators
Generate code from scratch with easy-to-use visual interfaces! Code complex, error-proof code with minimal (or no) coding knowledge.
Loops
Easily generate code to loop through objects, numbers, arrays, and more.
Test if each item meets certain criteria.
Perform actions on each item.
Message Boxes
Easily create ultra-professional MessageBoxes and InputBoxes
Files
Build procedures that loop through files and folders. Perform actions on files that meet certain criteria.
Great for generating code to quickly merging together multiple files.
Arrays
Easily build code to work with Arrays, Collections, and Dictionaries.
Create them from scratch and use the easy-access buttons to perform actions on them.
Class & Property Builders
Simplify the process of creating classes and properties.
No more manual Get/Let Declarations!
Formats
Create and preview number formats.
Procedures
Generate VBA Procedures (Subs or Functions) with desired settings.
Save your default settings for future use.
Great for beginners to learn what Procedure options are available!
VBA Tools
Upgrade the outdated Visual Basic Editor! With VBA Tools to navigate, debug, and format code.
Formatting Tools
- Comment / Uncomment multiple lines
- Code indenter
- Remove excess blank lines
Misc. Utilities
- Sort code
- Show line numbers
- Mass import / export of code modules
- Copy & Paste UserForm controls & their code
Navigation Tools
- Back / Forward Buttons
- Create bookmarks and goto with shortcut keys
- Close all windows
- Close all windows except active
Excel / VBA Debug
- Check for hard-coded ranges in VBA
- See all procedure contents
- List named ranges and shapes
- Find Excel errors.
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 our
on
Average Rating!
See Pricing
Why Wait? Order Now
Beginner
Simple version for beginners
Lifetime license valid for 1 computer*
Interactive VBA Tutorial100 ready-to-use code examples
Procedure Builder
All other code generators
Coding tools
Create your own code library
Excel / VBA Model Debugger
$79
Add to Cart
*Single-use license code valid for 1 computer (life-time access)
Upgrade Anytime!
Professional
Standard Version
Lifetime license valid for 2 computers*
Interactive VBA Tutorial230+ ready-to-use code examples
Procedure Builder
All other code generators
Coding tools
Create your own code library
Excel / VBA Model Debugger
$119
Add to Cart
*Single-use license code valid for 2 computers (life-time access)
Upgrade Anytime!
Developer
Tools for serious developers
Lifetime license valid for 3 computers*
Interactive VBA Tutorial230+ ready-to-use code examples
Procedure Builder
All other code generators
Coding tools
Create your own code library
Excel / VBA Model Debugger
$159
Add to Cart
*Single-use license code valid for 3 computers (life-time access)
Upgrade Anytime!
Customer Reviews
FAQ and Other Information
FAQ
[fl_builder_insert_layout id=”13751″ type=”fl-builder-template”]Code Library
[fl_builder_insert_layout id=”13879″ type=”fl-builder-template”]Code Tools
[fl_builder_insert_layout id=”13850″ type=”fl-builder-template”]Code Generator
[fl_builder_insert_layout id=”13796″ type=”fl-builder-template”]
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).
Disclaimer: AutoMacro is a product of ToolFive Software LLC. PowerSpreadsheets.com is a registered affiliate and will receive an affiliate commission from any sale from this webpage.
