Features that Beginners will love:
Features Experienced VBA Users will love:
Features Everyone will love:
Stop searching for VBA code examples online! Instead, simply use the AutoMacro add-in to easily insert commonly used code fragments into your module.
It's easy! Simply navigate to the menu, select the code fragment, click, and the code is added where your cursor is located:
The Object Builder makes it easy for anyone to write VBA code from scratch!
Most Excel VBA work is manipulating objects like Ranges, Sheets, and Workbooks. You manipulate these objects by either applying a method (an action like Copy or Paste) or a property (cell value or cell color).
With a click of the mouse in AutoMacro you can apply a method or property to an object.
1. Navigate to the Objects menu and select your desired method or property.
2. Your code will be inserted directly into the module where your cursor was located.
By default, the Object Builder will automatically use the active workbook, sheet, and range when generating the code:
You can turn this off and use Object variables instead:
The Procedure Builder allows you to create procedures with specific application settings, error handling, and more. No more searching online for how to disable ScreenUpdating or Automatic Calculations!
Beginners will find this feature useful to understand and implement procedure settings. Advanced users may find this to be a big time saver.
Do you find yourself using similar code over and over again across multiple workbooks? If so, you can save your own code to the custom code folder and easily access it whenever you want! It's easy:
1. Highlight the Desired Code
2. Navigate to 'Custom Code' and click 'Add Code'
3. Name your code fragment and click 'Save'
4. Click your code fragment and insert it into your module. Or... Better yet, use the "Alt Accelerator" keyboard shortcut to insert saved code with just a few keystrokes.
Easily comment-out multiple lines of code at once with the shortcut CTRL + ALT + C.
CTRL + ALT+ C
....or by selecting the option from the right-click menu
Create Bookmarks with the shortcut CTRL + ~.
- Bookmarks allow you to "bookmark" a location and easily return to it later.
CTRL + ~
Use CTRL + 1 (CTRL + 2) to navigate to the next (previous) bookmark.
CTRL + 1
Every code fragment and tool is easily accessible with 'ALT' keyboard shortcuts
Simply press 'Alt' and then type the underlined letter in your desired code fragment.
Example: ALT > B > C > L will insert the code fragment 'Last Column'
This even works with your own Custom Code Fragments!
Can I try AutoMacro before I buy? Yes! You can download AutoMacro here: http://www.automateexcel.com/automacro/download-walkthrough . 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: [email protected] .
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 was designed to work on all Microsoft Windows systems (7,8,10, etc. and 32-bit or 64-bit). It will also work on all versions of Microsoft Office (2007, 2010, 2013, 2016), including 64-bit Microsoft Office. Try the download link above to make sure!
Will my company pay for AutoMacro? 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!
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 Standard version entitles you to a single-use license code valid for 2 computers for which you are the primary user.
Does AutoMacro work with PowerPoint or Word? 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.
What are the exact differences between the Beginner and Standard Tiers?
Note: These are the differences between the tiers, not a full list of the features!
Life-time license valid for 1 computer*
Life-time license valid for 2 computers*
Other questions? Contact [email protected]
When I first learned VBA, I searched online countless times for the same basic code.
In fact, even as an experienced VBA user, there were many simple, yet uncommon commands that I found myself searching for online.
AutoMacro solves this problem.
Instead of breaking my train of thought to search online, find the right page, copy and paste the code, I simply use a few keystrokes to insert the code directly into my project.
I also save my own custom code fragments for code that I use across multiple projects, saving me the hassle of opening up workbooks just to copy+paste the code.
For a beginner VBA user, AutoMacro is a life-saver. You'll code much faster, learn VBA much faster, and decrease the likelihood of giving up on learning this powerful coding language.