#VISUAL BASIC COMMENTING HOW TO#
#VISUAL BASIC COMMENTING FULL#

This is where the Visual Basic Editor (VBE) built-in вЂњComment BlockвЂќ feature is useful. If you want to comment many lines at a time, it might be very cumbersome and time tacking to do one line at a time.

There must be a space between Rem and the comment.

#VISUAL BASIC COMMENTING FULL#

The Ren keyword works only for full line comments unlike apostrophe that works for both full line and inline comments.

You just have to replace the apostrophe by Rem as in the screenshot below: This method is similar to the previous one using apostrophes.

If your comment is on many lines, then you should begin each new line with the apostrophe.

That is why you can comment a code to disable it or uncomment it if you want it to be executed.

Any code that is within the comment block will not be executed.

A comment is easily identifiable by the green font color.

All you need to do is to place the apostrophe at the beginning of the comment.

You can put a comment on a separate line or at the end of a code line.

Step 3: Write any line of text beginning with the apostrophe. Step 1: Open a new Excel sheet and click on the developer tab or click on ALT + F11.

#VISUAL BASIC COMMENTING HOW TO#

To do that, first open the Visual Basic Editor (VBE) вЂ“ follow the steps below if you donвЂ™t know how to open the VBE.

This method is mostly used when you want to comment a single line. In the following examples, we are going to look at each of them.

Choosing the best method depends on the number of lines involved. There are three main ways to can write a comment in VBA. Better organize your code for easier readability, modifications, and teamwork.Temporally disable a line of code or a macro if you do not want to delete and rewrite it again.Provide a brief explanation about a function, a line of code or a macro.Some of the reasons why we use comments are: Though comments are not mandatory, they can be very useful. Each programming language has his own way to make a comment, in this article, you are going to learn how to make a comment in VBA. They are also not mandatory, but it is a good practice to use them in your coding habits, especially if you are working in a team. In programming, a comment is a statement that is used to explain a line of code or a whole procedure. How to uncomment a commented line or block.

Visual basic commenting