Rem comment ' comment
A textual comment to place within the code.
Use the Rem statement or an apostrophe (') to place remarks within the code.
Rules at a Glance
Text or code commented out using either the Rem statement or an apostrophe isn't compiled into the final program and therefore doesn't add to the size of the executable.
If you use the Rem statement on the same line as program code, a colon is required after the program code and before the Rem statement. For example:
Set objDoc = MyApp.MyObj : Rem Define the object Rem reference
This isn't necessary when using the now more common apostrophe:
Set objDoc = MyApp.MyObj ' Define the object reference
Apostrophes held within quotation marks aren't treated as comment markers, as this code snippet shows:
myVar = "'Something'"
Programming Tips and Gotchas
The VB and VBA development environments contain block comment and block uncomment buttons on the Edit toolbar, which allow you to comment out or uncomment a selection of many rows of code at once.
You can also use the line continuation character ( _ ) with comments, as this snippet shows:
'this is _ a comment _ on more than one line