Hello,
I am still new to VBA IDE. I am wondering if there is add-in or tools to make VBA do auto indentation like Eclipse editor for Java.
Any help are very appreciated. Thanks in advance.
Hello,
I am still new to VBA IDE. I am wondering if there is add-in or tools to make VBA do auto indentation like Eclipse editor for Java.
Any help are very appreciated. Thanks in advance.
Auto Indentation for VBA
Czar Eclarinal
Go to Tools|Options.
On the Editor Tab there is a "AutoIndent" checkbox.
I'm sure you can handle it from there. (unless you are looking for a tool to re-structure the indents in poorly indented code.)
rusty
Sam Vella
pvulcan
Excel MVP Stephen Bullen has a Smart Indenter add-in on his web site, two versions in fact, VBA and VB6. Stephen's site is at http://oaltd.co.uk
- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______
Beyond Blue