Single Line Comments | Block Comments

Today, I’ll show you how to add comments to your Visual Basic Editor.

My goal with these Excel VBA tutorials is to get you to the point where you’re able to write macros with your eyes closed. Once you start writing complex macros, you’ll appreciate the little notes you embed deep within your code. It’s easy to get lost in your macros, especially if you haven’t looked at them in months.

Single Line Comments

Any text appearing after an apostrophe will be ignored by the VBA interpreter. The example below shows comments added to the Chapter 1.3 macro.

Macro comments

Commented lines show up green in the Visual Basic Editor. You can use the apostrophe to comment out entire lines or to comment characters at the end of a line.

Comment Blocks

Sometimes you have entire blocks of code you want to skip over. You can comment out the block with the aptly named “Comment Block” feature. For such a useful feature, it bothers me that this isn’t readily-accessible by default. To access the comment block feature, follow these steps:

  1. From the Visual Basic Editor, click View
  2. Hover over Toolbars
  3. Click Edit
    VBA edit toolbar
    You may want to dock the Edit toolbar to the top of your editor; it can come in handy.

  4. Highlight the block of code you want to comment
  5. Click the Comment Block button
    VBA comment blocks

Your entire block of highlighted code will now be fully commented out.
VBA comment blocks

To uncomment the code, highlight the code and click the Uncomment Block button to the right of the Comment Block button you clicked earlier.

In this lesson you learned how to comment individual lines and how to comment entire blocks of code at once. Commenting is a fundamental skill that, if used appropriately, will greatly enhance the readability of your Excel macros.