| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
vba code format
hey all,
is there a way to format vba code automatically with indents and such? (like a shortcut key to press or something) thanks, rodchar |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba code format
For new VBA code, you should have the Auto Indent enabled. In the VBA
Editor, go to the Tools menu, choose Options then check the Auto Indent setting. This will indent code as you type but doesn't indent existing code. For that, you should get your hands on Stephen Bullen's Smart Indent add-in, free to download from http://www.oaltd.co.uk/Excel/Default.htm , about half way down the page. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "rodchar" wrote in message ... hey all, is there a way to format vba code automatically with indents and such? (like a shortcut key to press or something) thanks, rodchar |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
vba code format
cool, thanks for the tip.
rod. "Chip Pearson" wrote: For new VBA code, you should have the Auto Indent enabled. In the VBA Editor, go to the Tools menu, choose Options then check the Auto Indent setting. This will indent code as you type but doesn't indent existing code. For that, you should get your hands on Stephen Bullen's Smart Indent add-in, free to download from http://www.oaltd.co.uk/Excel/Default.htm , about half way down the page. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting www.cpearson.com (email on the web site) "rodchar" wrote in message ... hey all, is there a way to format vba code automatically with indents and such? (like a shortcut key to press or something) thanks, rodchar |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Code to conditional format all black after date specified in code? | Excel Discussion (Misc queries) | |||
| Code Date Format Depending on Computer format | Excel Discussion (Misc queries) | |||
| how to format code in VBA? | Excel Programming | |||
| code to convert date from TEXT format (03-02) to DATE format (200203) | Excel Programming | |||
| code for converting data format in another format | Excel Programming | |||
Hybrid Mode
