Quick Note on Formatting

Because StackExchange uses Markdown, 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(b as Integer)

to

Public Sub a(b as Integer)

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 hear, you can use lang-vb or lang-vbs, respectively for highlighting