Keyboard Shortcut for VBA Comments

VBA lacks a keyboard shortcut for commenting. This is a standard feature in modern IDEs, however, the VBA Editor is not modern, so we are forced to tolerate its drawbacks.

Comments are denoted using a single quotation mark (‘). Block comments can only be achieved by placing this symbol on each line of text. Instead of manually doing it, the Edit toolbar gives you access to the Comment Block and Uncomment Block buttons.

Whilst these are useful, it’s a bit tedious having to move the mouse cursor every time you want to comment or uncomment a section.

Thankfully, there is a workaround, which is explained in the document.

Whilst I’m at it…

Remember to comment your code, folks!

Irrespective of the programming language, detailed commenting helps you understand what each line does, and it also helps others who may be using your code.