VBA-Linter

Lint VBA code

Check that code parses correctly. If so, check that the formatting meets a specified standard.

Formatting Checks

E1 Indentation

• E101 indentation contains mixed spaces and tabs

E2 Whitespace errors

• E201 whitespace after '('
• E202 whitespace before ')'
• E203 whitespace before ‘,’
• E211 whitespace before (

W1 Indentation warning

• W191 indentation contains tabs - should be error.

W2 Whitespace warning

• W201 no newline at end of file
• W291 trailing whitespace
• W293 blank line contains whitespace

W3 Blank line warning

• W391 blank line at end of file

W5 Line break warning

• W500 incorrect line ending
• W501 line too long

To Do

• E221 multiple spaces before operator
• E222 multiple spaces after operator
• E712 comparison to True should be ‘If cond Then’
• E713 comparison to False should be 'If Not cond Then'
• F841 local variable 'foo' is assigned to but never used
• W101 improper indentation level
• W301 Too few blank lines before function
• W302 Too many blank lines before function
• N800 Keyword formating
• N801 Module name format
• N802 Function name format
• N803 Variable name format
• Missing Strict
• Variable not initialized
• return type not specified
• parameter type not specified
• missing function docbloc