PDA

View Full Version : Solved: Alignment on coding page



venson0801
07-16-2010, 01:35 PM
Hello guys, I just started to learn VBA by myself 2 weeks ago, and I have a question about writing the code. For my code, every line starts from the left, on every "If, while, for....etc", I am wondering is there a way to view it with some spacing on it? Like when you are doing VB2008, so you could see the sections clearly. By the way, I am using office 2007 and Ctrl +F11 to the code page.

Thank you so much for taking the look.

Tinbendr
07-16-2010, 01:42 PM
I use Smart Indent (http://www.oaltd.co.uk/Indenter/IndentFrm.htm) add-in, but it's for 2003.

Then there's MZ-Tools (http://www.mztools.com/v3/download.aspx).

Bob Phillips
07-16-2010, 01:56 PM
I just insert tabs!

venson0801
07-16-2010, 02:01 PM
Thanks guy, I thought they had a built-in function to do that on excel. Tinbebdr, I download MZ-tools and trying it now; xld, thanks again XD.