Quick Note on Formatting

Because StackExchange uses Markdown and Prettify.js 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

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

Quick Note on Formatting

Because StackExchange uses Markdown and Prettify.js 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

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

VBA Language Tags

<!-- language: lang-vb -->

<!-- language-all: lang-vb -->

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

Quick Note on Formatting

Because StackExchange uses Markdown and Prettify.js 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

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

Quick Note on Formatting

Because StackExchange uses Markdown and Prettify.js 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

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

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(ByRef b As Integer) ''# this is a comment

to

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

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

Quick Note on Formatting

Because StackExchange uses Markdown and Prettify.js 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

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