Moving from MZ-Tools 3.0 to 8.0 Part 31: It’s about time: A line indenter and line indentation review

In build (May 1, 2016) two new features have been introduced: a line indenter and a line indentation review (part of the Review Quality feature).

The line indenter has been the most requested feature in the last years, and after all these months working on bug fixes since the release of MZ-Tools 8.0 for VBA/VB6/VB5 on October 2015, finally this new feature has been added:


The line indenter uses the Tab Width that you have defined in the Options window of VB/VBA (Editor tab, Code Settings section) and is customizable through a couple of options in the Options window of MZ-Tools, Team Options tab, Line Indenting section:


The line indenter works without additional dialogs if the cursor is inside a method, or otherwise it shows a dialog to select the scope (project, file, etc.). Handy menu entries in the context menu of the Project Explorer are also provided.

But the line indenter is only half of the story. Wouldn’t be nice to know which methods have some line that is not correctly indented? The new Line Indenting Review, which is part of the Review Quality feature, provides that information:


When executed, it reports the first line of each method whose indentation is not correct:


So, with these two new features you can be more productive, get your code more formatted and you can increase the quality of your source code.

1 thought on “Moving from MZ-Tools 3.0 to 8.0 Part 31: It’s about time: A line indenter and line indentation review

  1. Yay! I didn’t realize this was your most requested feature, but it makes sense. Since Stephen Bullen’s addin no longer seems usable in Excel 2016, I had thought how great it would be if MZ-Tools filled the gap. So thanks very much.

    There’s one thing that I miss in your version: the ability to keep it from indenting the entire code body. I don’t the code itself and just rely on spacing to identify the beginning and ending of subs, functions, etc.

Comments are closed.