Do you know not to put Exit Sub before End Sub? (VB)

Updated by Brook Jeynes [SSW] 1 year ago. See history

123

Do not put "Exit Sub" statements before the "End Sub". The function will end on "End Sub". "Exit Sub" is serving no real purpose here.

Private Sub SomeSubroutine()
'Your code here....
Exit Sub ' Bad code - Writing Exit Sub before End Sub.
End Sub

❌ Figure: Bad example

Private Sub SomeOtherSubroutine()
'Your code here....
End Sub

✅ Figure: Good example

We have a program called SSW Code Auditor to check for this rule.

acknowledgements
related rules