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 helpful time-saving tools and utilities.

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



The Loop Builder generates code to loop through objects (ex. cells, sheets, or shapes), arrays, or numbers, performing action(s) on some or all of the items in the loop.

Loop Through
The Loop Builder can generate code to loop through the following items:

Cells
Sheets
Workbooks
Shapes
Charts
PivotTables
Tables
Numbers
Array Items

The MessageBox Builder generates code for MessageBoxes and InputBoxes.

A couple things of note:

You can define a default button by clicking the specific button in the "Buttons and Default Button" section. This is the button that will be pressed if the user clicks Enter when the MessageBox is shown. In the previous two images, the option "No" was selected as the default button.

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

Arrays
Create Arrays, Collections, and Dictionaries from scratch.

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

Files
Generate procedures to loop through files in a folder, performing actions on files that meet certain criteria.

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.



Only for V.I.P