Edit

Rem statement

  • Article

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.

See also

Support and feedback

Have questions or feedback about Office VBA or this documentation? Please see Office VBA support and feedback for guidance about the ways you can receive support and provide feedback.