indenting VBA code

[John Keith]

On the menu bar under FORMAT there is a option for Horizontal Spacing.
This looks like it could be very useful but whenever I try to use it
the options are grey out. How do I make use of this potentially useful
tool?


John Keith
(e-mail address removed)

 

[Chip Pearson]

Those features are for aligning controls on a userform while you are
working in the form designer. They do not have anything to do with
code.

Cordially,
Chip Pearson
Microsoft Most Valuable Professional
Excel Product Group, 1998 - 2009
Pearson Software Consulting, LLC
www.cpearson.com
(email on web site)

 

[OssieMac]

Hi John,

It is used in formatting the objects in userforms like equal spacing etc.
Need a userform open and select objects on the form to be able to use the
options.

 

[John Keith]

Those features are for aligning controls on a userform while you are
working in the form designer. They do not have anything to do with
code.

Bummer!

Thanks for correcting my misunderstanding.


John Keith
(e-mail address removed)

 

[Charles Williams]

But if you what you want is to automatically Indent your VBA code use
Stephen Bullen's Smart Indenter:
http://www.oaltd.co.uk/Indenter/Default.htm

I strongly recommend it

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[John Keith]

On the menu bar under FORMAT there is a option for Horizontal Spacing.
This looks like it could be very useful but whenever I try to use it
the options are grey out. How do I make use of this potentially useful
tool?

I have learned that if a block of rows of code is highlighted and then
either tab or shift-tab is pressed the selected lines will be adjusted
horizontally. This is a big improvement over individually adding or
deleting tabs!


John Keith
(e-mail address removed)

 

[Gary Keramidas]

like charles mentioned, download Smart Indenter.