Tools Toolbar

Most of AutoMacro’s tools can be accessed via the Tools Toolbar:

vba tools toolbar

Some can also be accessed via the right-click menu:

right click vba tools

AI

vba ai tools

With an active subscription, you can access AutoMacro’s AI features:

ai vba code generator

The AI tools include:

  • AI Chat Bot
  • AI Code Generator
  • AI Code Commenter
  • AI Code Explainer
  • AI Code Debugger

Click Learn More to learn more about these features.

Code Explorer

vba code explorer

AutoMacro’s Code Explorer improves upon the VBA Editor’s. By clicking on a code module, you can see it’s procedures. Double-click on the procedures to navigate to them.

vba project explorer

Find All

vba find all

AutoMacro’s Find All feature mimics the Find All found in Visual Studio.

vba editor find all
  • Simply right-click on a word and click “Find All”
  • Then you can see the location of each found reference.
  • Click on a reference to go to it.
  • Check which references you want to replace and do a “Replace All”

Comment / Uncomment Multiple Lines of Code

vba comment code

The comment / uncomment feature allows you to quickly comment or uncomment multiple lines of code at once. The feature is smart enough to identify when some lines of code are commented and others are not, so if you have a block of partially commented code, you can quickly standardize the commenting.

comments / uncomment before and after

The commenter is also available from the right-click menu and with the shortcut CTRL + ALT + C.

Display Line Numbers

vba line numbers

Display Line Numbers adds line numbers to your VBA code. This can be helpful for reviewing code, especially if you print it.

vba display line numbers

Sort Code

vba sort code

Sorting code, allows you to quickly re-arrange your code modules without copying/pasting.

display line numbers toolbar

Auto Indent

vba auto-indent

Auto Indent adds proper code indentation to the active module.

Proper indentation makes your code easier to read and reduces the chances of errors.

By default the code indentation will indent all code one “tab” to start. This setting can be changed in the Settings Menu:

auto indent before after

Remove Excess Linebreaks

vba linebreaks

Often when coding, blank lines can accumulate. The remove Excess Linebreaks tool (left button) scans your active code module and deletes blank lines whenever more than two consecutive blank lines are found. The right remove excess linebreak buttons, scans all of your code modules, removing excess linebreaks in them all.

Use this in conjunction with the Auto Indent tool to quickly clean up your code.

remove excess line breaks before after

Mass Import / Export Modules

vba import export modules

The Visual Basic Editor allows you to import or export modules and UserForms. Unfortunately, it only allows you to import or export one module at a time.

AutoMacro adds in the ability to mass import or export modules and UserForms. To access the features, use the toolbar buttons or right-click in the VBAProject window.

mass import export modules

Back and Forward Buttons

vba back forward buttons

The Back button allows you to go back to the previous code location. The Forward button returns to the original code location.

The commands store your code position history, allowing you to jump back/forward several code positions.

Bookmarks

vba bookmarks

Bookmarks are used to save code positions in a VBA Project.

Use the shortcut CTRL + ~ to create a bookmark (or the left toolbar button):

vba code tools bookmarks before after

and the shortcuts CTRL + 1 and CTRL + 2 to “jump” to the previous or next bookmarks (or the right toolbar button):

vba code tools bookmarks toggle

Close All Windows

vba close windows

Quickly close either all windows or all windows except the active window with these two buttons.

Copy UserForm Controls and Code

The Visual Basic Editor allows you to copy / paste controls from one UserForm to another. Unfortunately, when you do this the associated control code isn’t copy / pasted along with the control.

AutoMacro adds the ability to copy and paste the code along with the control. To access this feature, select your desired control(s) and select “Paste Special”. Then go to the destination UserForm and choose Paste Special to paste the control(s) and the associated code.

copy paste userform control

Clipboard History

clipboard history

The Clipboard History keeps a history of items copied to your clipboard, allowing you to easily paste them again in the future.

You can clear the history with the eraser button. Or disable this feature altogether from the Settings menu.

< Previous

AutoMacro AI

Next >

Loop Builder