This page has 0 threads | Add post

Blogs

Finding our blogs useful? Please consider helping us to share more!

Commenting out code in VBA Part two of a three-part series of blogs
Commenting code is an art form! This series of blogs explains why, how and when to comment in VBA. Why Write Comments in Excel Visual Basic Adding Comments in VBA macros for Excel (this blog) Commenting Out Code in Excel Visual Basic This blog is part of our Excel macros online tutorial series. Alternatively, come on one of our VBA classroom training courses.

Commenting out code in VBA

Part two of a three-part series of blogs

Commenting code is an art form! This series of blogs explains why, how and when to comment in VBA.

Why Write Comments in Excel Visual Basic
Adding Comments in VBA macros for Excel (this blog)
Commenting Out Code in Excel Visual Basic

This blog is part of our Excel macros online tutorial series. Alternatively, come on one of our VBA classroom training courses.

Posted by Andy Brown on 28 April 2011

Adding Comments in VBA

This online training blog shows how to add comments to VBA (Visual Basic for Applications) code. The ideas shown work in Access, Word, PowerPoint and all other MS Office applications, but the diagrams come from Excel Visual Basic.

An example of commented code in Visual Basic for Excel

Writing Comments

Any comment in VBA begins with a single apostrophe character ('). When you type in a comment and press the Enter key, the line will go green. For comments spanning multiple lines, you'll need to type the ' key multiple times:

This comment runs for 2 lines

Note that there is one other way to get multiline comments, and that's to use an _ underscore continuation character after all but the first lines:

It seems easier to this owl just to use repeated apostrophes!

Note that comments don't have to start at the beginning of lines:

Anything after the apostrophe in each line will be ignored by VBA

Changing the Colour of Comments

If you don't like the colour green - change it! The first thing to do is to go into the VBA editor's options:

First, go into the VBA code editor's options dialog box as shown on the left.

Now choose to change the colour for your comments as follows:

To change the comment colour:

You can also comment out code, as described in the next blog in this series.

Parts of this blog
Why Write Comments in Excel Visual Basic Adding Comments in VBA macros for Excel (this blog) Commenting Out Code in Excel Visual Basic

Some other pages relevant to the above blogs include:

This blog has 0 threads

Add a new post

Head office

Kingsmoor House

Railway Street

GLOSSOP

SK13 2AA

London

Landmark Offices

99 Bishopsgate

LONDON

EC2M 3XD

Manchester

Holiday Inn

25 Aytoun Street

MANCHESTER

M1 3AE

Site map

Terms & Conditions

Book any course as classroom, onsite or online training, or as one-to-one consultancy

Free resources

Paid services

Getting help

Where we are

Where you are

Online

Transparent reviews

Delivery of courses

Nicer to work with

Reliable and established

Our training courses

C#

Excel

MySQL

Power Apps

Power Automate

Power BI and DAX

Python

Report Builder

SQL

SQL Server

VBA Macros

Other training resources

Blogs

Exercises

YouTube tutorials

YouTube shorts

Test your skills

Consultancy

Courseware

Self-paced courses

Newsletters

Publications

Our training venues

London

Manchester

Across the UK

At your site

Online

Why we are different

Hundreds of published reviews

Small class sizes

Outstanding courseware

Online classroom

(Almost) no cancellations

Wise Owl trainers only

Genuine integrity

Invoices after training

30+ years of Wise Owl

Our top 100 clients

BLOGS BY TOPIC

BLOGS BY AUTHOR

Adding Comments in VBA

Writing Comments

Changing the Colour of Comments

Head office

London

Manchester