Friday, January 29, 2010

Comments in VBA

In VBA Comments can be written in two ways:

A comment can start with a single quote (')
eg: 'this is an example
or
It can start with (REM)
eg: REM this is another example

REM cannot come in between the line where as ' can start anywhere in the line.
REM is taken from BASIC Programming.

Also, there is no multiline commnet in VBA. For that we need to use the comment block on the edit toolbar of VBE.

Regards,
Praveen KVC
28 January 2010

0 comments:

Post a Comment