VBA: Code Indenter

Automate Excel

VBA: Code Indenter

indentJohn Mansfield posted a few months ago about the Smart Indenter addin. I finally got around to a test driving it today.

If you need your code to be presentable, get sloppy with longer modules, or would like to see your code indented uniformly for the first time<g>, I’d recommend giving the Smart Indenter an evaluation(also it’s free).

Notes:
After installing, the Smart Indenter will be located under your Visual Basic Editor’s Edit menu.

The Smart Indenter gets a line item in “Add or Remove Programs”, located in the Control Panel, so uninstall is easy if it’s not for you.

The Smart Indenter comes with a handful of options that you can modify however there isn’t a reset button. So keep a mental note of the default options you modify because there is no obvious way to restore them.

The Smart Indenter doesn’t remove excess line breaks in code. Sure, the name didn’t suggest it would, however this would be a nice addition. I indent rather well but get liberal with line breaks occasionally.

One Response

  1. Stephen Bullen Says:

    Thanks for trying the Smart Indenter. Suggestions for new features are always welcome, to stephen@oaltd.co.uk. As you change the indenting options, the code snippet updates to show how the option affects the code. Simply Cancelling the Options dialog will revert back to the original choices.

Leave a Comment

Please note: Comment moderation is enabled and may delay your comment. There is no need to resubmit your comment.