home page
Questions? E-mail us or call us 302-234-9857, 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.

Product: Smart Indenter     Customers who looked at this product also looked at:
For: Excel 97 to Excel 2010  

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.

Price: free
Company: Office Automation
Location: .UK
Email support: yes
Phone support: no

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.  We recommend opening COM add-ins on demand only by using the Add-In Information Lister, which provides easy access to the COM add-in control panel.  And un-installing COM add-ins as soon as they are not needed.

The home page of the Smart Indenter states that there are versions for Excel 97-2003.  We have run and used in Excel 2007- 2013 with no problems.

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 2013 LLC, all rights reserved.  Spreadsheet Assistant is a registered trademark of LLC.