Rem statement
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.