Coding Conventions

Separators

• '##########

Organization

• called functions after calling functions
• grouping functions (VBA Access Form: Form, Controls, Methods)

Function Names

A function name

• describes what the function does
• starts with a verb
• starts lowercase

Sub reportDifference()
    '...
End Sub

Blank lines

• Dim block
• if, select, etc

Name parameters

• Param:="Xyz"

Obsolete constructs

• Call
• Set Nothing