Make Comment or Explanation On Code of Excel Macro

To make explanation/comment on code of excel macro, place the explanation/comment on the right-most of a line of code of excel macro, and before the explanation/comment use single quote ('). Characters in explanation/comment or characters after single quote (') will not affect code of excel macro. Characters as explanation/comment will colored green.

Example:

Sub namaSub()    MsgBox "Keep cleanliness" 'These characters after this single quote will not affect macro code    MsgBox "Because cleanliness is part of faith" 'This is second message will show End Sub

Source: Tutorial Excel Indonesia: https://www.youtube.com/watch?v=CjeC1lqQuwI

Posted in: