Wrong highlighting on stackoverflow.com vba if default is used about code-prettify HOT 1 OPEN

First off, this is not a Prettify bug; it's a Stack Exchange-specific issue. These should be posted on https://meta.stackoverflow.com.

Second, there's not a whole lot we can really do when there are multiple tags, each implying their own syntax-highlighting scheme. The [vba] tag is already set to assume "lang-vb" for syntax highlighting, but the [sql] tag also appears on that question, and it is set to assume "lang-sql". When a conflict occurs, as you said, Stack Overflow reverts to the "default" syntax highlighting, which is...not great. But how could it be?

Stack Overflow does allow you to work around this problem using an explicit syntax-highlighting hint. The format is:

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

right above the code block, or:

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

to affect the entire post.

See also Syntax highlighting for code in the Help Center.

from code-prettify.