indenting of vba code 1

[electricpete]

I notice that vba is good at putting colors into my code to make it more readable.

I vaguely remember that it used to indent for readability but now it doesn't anymore.

This code ends up all left justified
If 3 > 2 Then
MsgBox ([var1])
End If

Why doesn't it indent the middle line?



=====================================
Eng-tips forums: The best place on the web for engineering discussions.

 

[CajunCenturion]

In the VBA editor check Tools=>Options, and select "Editor Tab". I believe there is an "Auto Indent" checkbox on that form.

Good Luck
--------------
As a circle of light increases so does the circumference of darkness around it. - Albert Einstein

 

[joerd]

Cajun's solution will indent the next line if you have indented a line. So you'll have to indent pretty much yourself. A good - and free - automatic indenter is SmartIndent (

http://www.bmsltd.ie/indenter/default.htm)

Cheers,
Joerd

Please see FAQ731-376 for tips on how to make the best use of Eng-Tips.

 

[electricpete]

Awesome. Thanks guys.

=====================================
Eng-tips forums: The best place on the web for engineering discussions.