microsoft excel training - Comments - paragraph

The UK's most regular instructor-led training courses.
Training information: microsoft excel training · Excel-courses-london · VBA courses London UK

Resolved · Low Priority · Version Standard

Comments - paragraph

Clement has attended:
Excel VBA course

by - delegate Clement [1 post] (2008 Jan 28 Mon, 11:21) Reply

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?

Version	Date	Location	Places available	Book	Next place rate:
Excel Intermediate 1 day course
Version	Date	Location	Places available	Book	Card	Invoice
2002/XP	2008 Aug 29 Fri	Tooting	0	FULL
2003	2008 Sep 2 Tue	Bloomsbury	3	book now	£210	£215
2003	2008 Sep 4 Thu	Bayswater	4	book now	£195	£205
2007	2008 Sep 4 Thu	Bloomsbury	0	FULL
2003	2008 Sep 9 Tue	Bloomsbury	4	book now	£207	£215
2002/XP	2008 Sep 9 Tue	Tooting	0	FULL
Full Schedule: See all 138 Excel Intermediate course dates. Bookings currently available until 25th November 2009.

RE: Comment on VBA Code

by - trainer Katie gold contributer [208 posts] (2008 Feb 12 Tue, 12:46) Reply

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