commenting a chunk of code in VBA

stimulator · Apr 9th, 2002, 02:38 PM

Does anyone nows how to comment a chunk of code in vba (more then a line without using the single quote)?

Mark O'Brien · Apr 9th, 2002, 02:41 PM

I do not believe this is possible. Which is sort of a shame really. You either use REM or ' and that's your lot.

Mark O'Brien · Apr 9th, 2002, 02:43 PM

Well I'll be damned, this still doesn't answer your question but you can use underscore to continue comments:



Rem ksjdhfkjsh _

sdjfkjshd



'sdkhfksjhkjsfh _

dsfsdlkfsjh

smozgur · Apr 9th, 2002, 02:43 PM

Same s like we do in long code lines:

'This is a multiline _
comment which has no single _
quote for each line

Regards

Mark O'Brien · Apr 9th, 2002, 02:50 PM

Yeah, it just doesn't make sense to me in comments though. Surely the REM or ' should instruct VBE to ignore all characters after it, on the same line.

Apr 9th, 2002, 02:41 PM	#2
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	I do not believe this is possible. Which is sort of a shame really. You either use REM or ' and that's your lot. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 9th, 2002, 02:43 PM	#3
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Well I'll be damned, this still doesn't answer your question but you can use underscore to continue comments: Rem ksjdhfkjsh _ sdjfkjshd 'sdkhfksjhkjsfh _ dsfsdlkfsjh __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Apr 9th, 2002, 02:50 PM	#5
Mark O'Brien MrExcel MVP Join Date: Feb 2002 Location: Columbus, OH, USA Posts: 3,519	Yeah, it just doesn't make sense to me in comments though. Surely the REM or ' should instruct VBE to ignore all characters after it, on the same line. __________________ Mark O'Brien Columbus Ohio Celtic Supporters Club

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 9th, 2002, 02:38 PM	#1
stimulator New Member Join Date: Apr 2002 Posts: 24	Does anyone nows how to comment a chunk of code in vba (more then a line without using the single quote)?

Apr 9th, 2002, 02:43 PM	#4
smozgur BatCoder Join Date: Feb 2002 Location: Turkey Posts: 764	Same s like we do in long code lines: 'This is a multiline _ comment which has no single _ quote for each line Regards