Quick Note on Formatting 
=

Because StackExchange uses [Markdown][1] and [Prettify.js][2] it is possible to add a language flag to your coding answers, which generally makes them look more professional. While I cannot guarantee that this will make you any better at golfing in VBA, I can guarantee that it will make you look like you are.

Adding either of the flags below will transform 

    Public Sub a(ByRef b As Integer) ''# this is a comment

 to  

<!-- language: lang-vba --> 

    Public Sub a(ByRef b As Integer) ''# this is a comment


_Note: there seems to be a bit of an error with the way that Prettify.js handles VBA, in that it assumes the literal `#` (the character used to indicate conditional compilation) to be the comment character, rather than `'`, which is handled like a char literal character. Because of this, I recommend starting comments with `''# ` when using prettify.js as it looks correct both to the compiler and to prettify.js_

__VBA Language Tags__

`<!-- language: lang-vba --> `  

`<!-- language-all: lang-vba --> ` 

_Note: the latter transforms all code segments in your answer, while the prior transforms only the immediately following code segments_

_Note, The Second: If you happen to be looking for VB or VBScript tips here, you can use `lang-vb` or `lang-vbs`, respectively for highlighting_


  [1]: https://en.wikipedia.org/wiki/Markdown
  [2]: https://github.com/google/code-prettify