Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
indenting VBA code
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
indenting VBA code
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I stop the footer from indenting? | Excel Discussion (Misc queries) | |||
Indenting numbers from the right side of a cell | Excel Discussion (Misc queries) | |||
excel indenting a group of rows | Excel Discussion (Misc queries) | |||
Tabbing/Indenting within a cell | New Users to Excel | |||
Indenting cells in Excel | Excel Discussion (Misc queries) |