home page
Questions? E-mail us or call us 302-584-1771, 8AM to 10PM U.S. East Coast Time 7 days a week


Money back

How to indent your VBA macro code
using the Smart Indenter

When you write your VBA macro code, it helps readability to indent the code.  For example, the statements between a For..Next loop are indented to show that they are within the loop.  One problem that seems to happen to everyone is the indentations get messed up!  Manually fixing is a pain.  Office Automation has released a free product called the Smart Indenter that will indent your code for you you.   To install, you must run as Admin.  Download and right click on the file and select 'Run as Administrator".

Product: Smart Indenter     Customers who looked at this product also looked at:
Install exe:   Install exe  

Macros Made Easy - A downloadable book (Windows help file format) on how to write macros for Microsoft Excel

Macro Examples - Get over 1200 macro examples for Microsoft Excel in a downloadable book (Windows help file format). These examples are new and not a repeat of the ones in Macros Made Easy.

For: Excel 2003 to Excel 2013 - 32 bit Excel only. Does not work in 64 bit
Price: free
Company: Office Automation, LTD
support: No support available - developer has retired.

Memory usage:  The Smart Indenter is a COM add-ins.  It fully opens all the time. COM add-ins typically use a noticeable amount of Excel memory.  However, this one is extremely small COM add-in.  We have found that having several large COM add-ins open at one time makes Excel unstable (all of our add-ins are VBA add-ins). To see if you have COM add-ins installed and to remove, use the Add-In Information Lister, which provides easy access to the COM add-ins control panel. 

When you install the Smart Indenter, it adds a menu item to the Edit menu of the Visual Basic editor.

Simply select the option you want to run, and click OK on the confirmation dialog.  Indenting an entire project is extremely fast.

There are quite a few options with the Smart Indenter:

options for indenting vba code





Copyright 2021 LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of LLC.