Indentation and White Space

White space is ignored in VBA and the editor will automatically discard any extra spaces.
If you type

myInteger    =    6 

This will be automatically changed to

myInteger = 6 

The exception is when whitespace is included within double quotes, as part of a string.


You can use the Tab key to indent your lines of code that logically belong together to make the code easier to read.
The tab key should be used instead of pressing the spacebar multiple times.
You can also use (Shift + Tab) to "unindent" your lines of code.
You can change the default tab size from the (Tools > Options)(Editor tab).

Function DoSomething() As Integer 
   Dim iNumber As Integer
   For iNumber = 1 to 5
      DoSomething = DoSomething + iNumber
   Next iNumber
End Sub

The Indent and Outdent buttons on the Edit toolbar can also be used on blocks of code.

Indent - Shifts all the lines (in the current block) to the next tab stop.
Outdent - Shifts all the lines (in the current block) to the previous tab stop.

Important

All code should be consistently indented with line spaces where appropriate.
Different parts of the code should be separated by using a blank line.
Indentation should be used to highlight the block structure and control statements.
Tabs must be used for indentation (4 which is the default).
One statement per line. Avoid putting multiple statements on the same line (ie using :). This makes debugging more difficult as the project might have to be reset after making dynamic changes. The only exception to this is if you are initialising a simple variable.


© 2019 Better Solutions Limited. All Rights Reserved. © 2019 Better Solutions Limited TopPrevNext