AutoMacro: VBA Code Library

Ready-to-use VBA Code - Available in the VBA Editor

vba code library

Compatible with

access vba code library

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!

VBA Code Library Cheatsheet

Code Library

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

Keep Reading...

Code Builders

  • Generate VBA code from scratch
  • Visual interfaces

Coding Tools

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

VBA Code Library

AutoMacro’s code library contains hundreds of commonly used code fragments for Excel, Access, Outlook, Word, and PowerPoint. As well as the ability to add your own code to the library.

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

vba objects code

Object Code Library

Easily manipulate objects like Ranges, Columns, Rows, Sheets, and Workbooks. Great for Beginners!

Learn More


The Settings library contains the most common Excel / VBA settings that you will use.

Great as a reference to see what settings are available!

Learn More

files code library


Code for working with files and folders. Learn More

More Code For Beginners

ifs vba code

More Code For Everyone

vba events code examples
vba text examples
vba code example add in arrays
vba code examples fxs
vba code library arrays

Code for Access, Outlook, Word, and PowerPoint

access vba code library
outlook vba code library
word vba code library
vba powerpoint code library

Custom Code Library

Create your own VBA Code Library.  Organize code into folders and access all code via keyboard shortcuts.

Share custom code folders with co-workers.

vba custom code library

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 B - USA

Other AutoMacro Features

Code Generators

Code Generators build code from scratch via visual interfaces.

No coding knowledge required!

vba code 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.

Why Wait? Order Now


Simple version for beginners

1 User - 1 PC



One-time fee

Upgrade Anytime!


Tools for serious developers & more

1 User - 3 Transferable PCs & Updates


$169 +

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

Upgrade Anytime!


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


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: 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:

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


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!

See this page from the IRS on Employee Business Expenses.

The Beginner version entitles you to a single-use license code valid for 1 computer. The Professional version entitles you to a single-use license code valid for 2 computers for which you are the primary user. The Developer version is valid for 3 computers.

Yes! AutoMacro functions in any program with the Visual Basic Editor. The code fragments are (currently) intended for Excel, but all features will work in any Visual Basic Editor environment.

Code Library

VBA Code Library: Easy access to 230+ ready-to-use code fragments and the ability to create your own code library.

Save Your Own Code

Create your own code library. Organize into folders. Share with colleagues.
Learn More


Toggle the most-used Excel / VBA settings.
Learn More

Keyboard Shortcuts

All code accessible via keyboard shortcuts. Simply look at underlined letters.
Learn More


Code for working with files and folders.
Learn More


Toggle the most-used Excel / VBA settings.
Learn More

Much More!

Ifs, Case Selects, Loops, Fors, MessageBoxes, Text, Dates, Times, and ready-to-use functions.
Learn More

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

"Saves me hours of work. Being able to store code snippets is a Godsend. Would definitely recommend!"

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