AutoMacro
VBA Add-In: Coding Tools, VBA Code Examples, and VBA Code Generators
What is AutoMacro?
AutoMacro:
- Is an add-in for VBA.
- Installs directly into the Visual Basic Editor (VBE).
Depending on the version, AutoMacro comes loaded with the following tools/features:
- Code generators;
- An extensive code library;
- The ability to create your own code library; and
- Advanced coding tools.
Code Generators
Code Library
Coding Tools
- Generate VBA code from scratch via visual interfaces
- Requires none/minimal VBA coding knowledge
- Massive time-savers for experienced programmers
- Hundreds of ready-to-use code examples
- Quickly/easily insert commonly-used code examples
- Create your own custom code library
- Improve the Visual Basic Editor
- Make coding in VBA easier
- Formatting and navigation tools
- Excel/VBA Model Debugger
VBA Code Generators
AutoMacro's VBA Code Generators:
- Build code from scratch via visual interfaces;
- Require none or minimal VBA coding knowledge; and
- Are massive time-savers for more experienced programmers.
Loops
Use the Loop Builder to build VBA code that does the following:
- Loops through objects/items.
- Performs actions with/on some/all of those objects/items.


Message and Input Boxes
Copy & Paste
Use the Copy & Paste Builder to build VBA code that does the following:
- Copy or cut; and
- Paste.


Arrays
Files
Use the File Processing Wizard to build VBA code that does the following:
- Loops through all files in a folder.
- Performs actions with/on some/all of those files.


Classes and Properties
Procedures


Formats
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
Code Generators
Code Library
Coding Tools
- Generate VBA code from scratch via visual interfaces
- Requires none/minimal VBA coding knowledge
- Massive time-savers for experienced programmers
- Hundreds of ready-to-use code examples
- Quickly/easily insert commonly-used code examples
- Create your own custom code library
- Improve the Visual Basic Editor
- Make coding in VBA easier
- Formatting and navigation tools
- Excel/VBA Model Debugger
Code Library
AutoMacro's Code Library contains hundreds of commonly-used code examples:
- The Beginner version contains 100 ready-to-use code examples.
- The Developer and Developer+ versions contain 230+ ready-to-use code examples.
You can insert these code fragments into your VBA code with:
- The click of a button; or
- Keyboard shortcuts.
Simply select the code from AutoMacro's menu and it will be inserted directly into your module.

Object Code Library
AutoMacro's Object Code Library allows you to:
- Interact with the objects that compose the Excel Application; and
- Learn about the hierarchy in which the objects that compose the Excel Application are organized.


Settings
Use the Settings Code Library to work with several commonly-used settings, including the following:
- Screen updating, which allows you to control whether screen updating is turned on or off.
- Automatic calculations, which allows you to specify Excel's calculation mode (for example, automatic or manual).
- Events, which allows you to disable events.
- Error handling, which allows you to specify how potential run-time errors are handled.
Files


Custom Code Library
With AutoMacro's Developer and Developer+ versions, you can do the following:
- Create your own Custom Code Library.
- Organize your code into folders.
- Access your custom code via:
- User-created menus; or
- Keyboard shortcuts.
- Share your custom code with friends and colleagues.
Join the Hundreds of Professionals Who Use AutoMacro
"I have only just scratched the surface of what's doable AutoMacro, and already I'm blown away! This is definitely money well spent for anyone who works with VBA regularly."
Jody L.
Code Generators
Code Library
Coding Tools
- Generate VBA code from scratch via visual interfaces
- Requires none/minimal VBA coding knowledge
- Massive time-savers for experienced programmers
- Hundreds of ready-to-use code examples
- Quickly/easily insert commonly-used code examples
- Create your own custom code library
- Improve the Visual Basic Editor
- Make coding in VBA easier
- Formatting and navigation tools
- Excel/VBA Model Debugger
Coding Tools
AutoMacro's (Developer and Developer+ versions) Coding Tools:
- Improve the Visual Basic Editor (VBE); and
- Make coding in VBA easier.
Formatting Tools
AutoMacro contains several VBA code formatting tools:
- Comment/uncomment multiple lines of code.
- Auto-Indent.
- Remove excess line-breaks.


Navigation Tools
AutoMacro contains several tools to help you quickly/easily navigate VBA Projects:
- Back and Forward buttons.
- Bookmarks.
- Close all windows.
Miscellaneous Utilities
- Display line numbers.
- Sort code.
- Mass import/export of modules.
- Copy UserForm controls and code.


Excel/VBA Model Debugger
Review/debug Excel/VBA models with the help of the following 5 reports:
- Excel Named Ranges Report.
- VBA Range Report.
- Shape Procedures Report.
- Procedures List Report.
- Formula Error Report.
Join the Hundreds of Professionals Who Use AutoMacro