Skip to main content

Rem statement

Table of contents
  1. Syntax
  2. Remarks
  3. Example

Used to include explanatory remarks in a program.

Syntax

Rem comment

You can also use the following syntax: ' comment

The optional comment argument is the text of any comment that you want to include. A space is required between the Rem keyword and comment.

Remarks

If you use line numbers or line labels, you can branch from a GoTo or GoSub statement to a line containing a Rem statement. Execution continues with the first executable statement following the Rem statement. If the Rem keyword follows other statements on a line, it must be separated from the statements by a colon (:).

Use an apostrophe (') instead of the Rem keyword. When you use an apostrophe, the colon is not required after other statements.

Example

This example illustrates the various forms of the Rem statement, which is used to include explanatory remarks in a program.

Dim MyStr1, MyStr2 
MyStr1 = "Hello": Rem Comment after a statement separated by a colon. 
MyStr2 = "Goodbye" ' This is also a comment; no colon is needed.

Leave a comment

Your email address will not be published. Required fields are marked *

Format your code: <pre><code class="language-vba">place your code here</code></pre>