vba code format

[Guest]

hey all,
is there a way to format vba code automatically with indents and such? (like
a shortcut key to press or something)
thanks,
rodchar

 

[Chip Pearson]

For new VBA code, you should have the Auto Indent enabled. In the VBA
Editor, go to the Tools menu, choose Options then check the Auto Indent
setting. This will indent code as you type but doesn't indent existing code.
For that, you should get your hands on Stephen Bullen's Smart Indent add-in,
free to download from http://www.oaltd.co.uk/Excel/Default.htm , about half
way down the page.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

 

[Guest]

cool, thanks for the tip.
rod.

For new VBA code, you should have the Auto Indent enabled. In the VBA
Editor, go to the Tools menu, choose Options then check the Auto Indent
setting. This will indent code as you type but doesn't indent existing code.
For that, you should get your hands on Stephen Bullen's Smart Indent add-in,
free to download from http://www.oaltd.co.uk/Excel/Default.htm , about half
way down the page.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)