How to format a code in module? Guidance please!

Hi friends,
I have inserted a module in a workbook.
Wrote a code for a macro.
The code is not left align.
I want to align it left.
To do it I select all the code and then in format tab I go to sub menu of format align left.
But the align left and all other options are not available. So I'm unable to align the code left.

Please suggest me a proper way to achieve the target.

Thanking you,

Alignment option is applicable for User Form controls.. like buttons, combobox..

Did you tried..
by pressing TAB / Shift + TAB..
In menu Section > EDIT Meny > then INDENT also available for mouse click..

In the VBEditor under Exel, the Preferences give you formatting options. It sounds like the margin indicator bar checkbox (Editor format tab) might be what you are looking for.

Hi mso,

See this page for better discriptions.

http://www.bettersolutions.com/vba/s...whitespace.htm

Hi mikerickson,
The margin indicator bar is checked but still the code is not in left align in the module. I select the extra spaces at left, delete it manually and manually align the code left align which is very laborious.

So suggest me a best way to do it quickly.

Thank you,

Hi mso,

Select the entire Subroutine by left clicking and dragging over the entire thing. While it is selected, press Shift Tab. Do this multiple times and all indented text will move left. The distance it moves left is determined by your default settings in your VBA Editor Options. That is in VBA > Tools > Options > Editor Tab > Tab Width.

Now select a few lines and while they are highlighted, click the tab key. What is selected will indent.

I hope that makes sense.

If you want help indenting code give this a go SmartIndenter.

Hi all,
Thank you for your valuable kind guidance.