View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jim Thomlinson Jim Thomlinson is offline
external usenet poster
 
Posts: 5,939
Default Block comments in VBA

Sorry the languages you list (of which C/C++ is a part) are all freeform
languages. They don't care about carriage returns or comments. They care
about semi colons.
--
HTH...

Jim Thomlinson


"Conan Kelly" wrote:

Jim,

Thanks for the feed back.

I already know about the Comment and Uncomment buttons on the toolbar. I use them quite regularly.

I was just hoping that VBA had a Start Comment character and an End Comment character, because they might be valuable in another
way. I would not use them to comment out multiple whole lines, but I think they might be useful to comment out sections of a single
line.

Thanks again for all of your help,

Conan Kelly




"Jim Thomlinson" wrote in message
...
Nope... Each line of comments must start with an apostrophe. C/C++ does not
care about carriage returns in the code so you can comment entire sections.
Here is what you can do. In the VBE bring up the edit tool bar and there are
two buttons on the bar "Comment Block" and "Uncomment Block". Select a group
of code and hit the button to automatically comment the entire section.
--
HTH...

Jim Thomlinson


"Conan Kelly" wrote:

Hello all,

Is there a way to do block comments in VBA instead of just the line comments (')?

--
Thanks for any help anyone can provide,

Conan Kelly