Forum home » Delegate support and help forum » Microsoft Excel VBA Training and help » microsoft excel training - Comments - paragraph

microsoft excel training - Comments - paragraph

ResolvedVersion Standard

Mon 28 Jan 2008, 11:21 Delegate Clement said...

Clement has attended:
Excel VBA Intro Intermediate course

Comments - paragraph

Is it possible to set a whole paragraph as a comment i.e. to avoid writing a apostrophe at the beginning of each line of the paragraph and instead just write a sign at the beginning and at the end of the paragraph to set it as a comment?

Tue 12 Feb 2008, 12:46 Trainer Katie said...

RE: Comment on VBA Code

Hi Clement,

Thanks for your question. Yes, you can set a comment block to multi-lines of VBA code.

1) In the VBA editor, switch on the EDIT toolbar.
2) Select the lines of code
3) Click on the icon: COMMENT BLOCK (i.e. the icon with black & blue lines, next to the hand icon)

See if that helps.

Regards,

Katie Woo
Microsoft Certified Trainer

Training courses

98.7 % recommend us

More live stats...

Training information:

Active questions
Advanced/consultancy questions
Today's questions
Unanswered questions
Popular forum topics

Excel tip:

Adding date and time

Here are two quick ways to add the date and time to your spreadsheet:

1) Type =NOW(), which displays both date and time in the same cell
or
2) Hold Ctrl and type the colon (:) into one cell for the date and the semi-colon(;)into another for the time.

Note that =NOW() updates to the current date/time whenever the spreadsheet recalculates.

View all Excel hints and tips

microsoft excel training - Comments - paragraph

Comments - paragraph

RE: Comment on VBA Code

Excel articles

Excel tip:

Adding date and time