Auto Indentation for VBA

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.



Answer this question

Auto Indentation for VBA

  • R.Tutus

    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
    _______



  • Sergey Sorokin

    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


  • ALS1234

    Thank you so much Jon. This works very well for me.
  • Anand Raman - MSFT

    Yes, I am looking for a tool to restructure the indents automatically. Thanks anyway.
  • Auto Indentation for VBA