indenting VBA code

J

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
[email protected]
 
C

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)
 
O

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.
 
J

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?
Click to expand...

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
[email protected]
 
Top