microsoft excel training - Comments - paragraph

Resolved · Low Priority · Version 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