indenting VBA code
 

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

indenting VBA code
 

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)

On Fri, 20 Feb 2009 09:09:08 -0700, John Keith wrote:

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

indenting VBA code
 

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.

--
Regards,

OssieMac


"John Keith" wrote:

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

indenting VBA code
 

On Fri, 20 Feb 2009 10:19:39 -0600, Chip Pearson
wrote:

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

indenting VBA code
 

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" wrote in message
...
On Fri, 20 Feb 2009 10:19:39 -0600, Chip Pearson
wrote:

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

indenting VBA code
 

On Fri, 20 Feb 2009 09:09:08 -0700, John Keith wrote:

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

indenting VBA code
 

like charles mentioned, download Smart Indenter.

--


Gary K



"John Keith" wrote in message
...
On Fri, 20 Feb 2009 09:09:08 -0700, John Keith wrote:

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