Commenting out blocks of code 2

[TonyJollans]

Hi All,

Just thought some of you who don't frequent the Access fora might find this of interest.

In thread705-774732, JeremyNYC gives a simple method of block-commenting using conditional compilation as an alternative to the VBA Editor method.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[VBAjedi]

Slick method! Have a star for the heads-up (and to draw attention to this thread).

Thanks!

VBAjedi

 

[VulcanJedi]

am i not understanding the question, but isn't it simpler to just use the toolbar function?

Tranpkp

 

[PHV]

tranpkp, say you have 20 lines of debugging code you want to comment out for production. I think it's simpler to encapsulate them with compile directives than to click 20 times the toolbar option.

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884

 

[combo]

Nice idea, red comment.
PHV,
you can comment block with one click using "Edit" toolbar. The items (comment and uncomment block) are available in "edit" category when you customize menu/toolbar.

combo

 

[PHV]

We have to learn every day. So, Thanks combo for this valuable post!

 

[VulcanJedi]

So am i still missing something, my edit or debug toolbars is one, of them! Has the comment / decomment buttons (look like blue indent buttons) and you can simply drag/highlight and click....actually takes one click??

Tranpkp

 

[TonyJollans]

Hi tranpkp,

No, you're not missing anything

Not everybody has the Edit Toolbar visible all the time. This is just another way that may be useful to some people in some circumstances.

Enjoy,
Tony

------------------------------------------------------------------------------------------------------
We want to help you; help us to do it by reading FAQ222-2244 before you ask a question.

 

[VulcanJedi]

I remember when I first found that thing, was like a godsend, sometimes hard to keep to toolbar on there...

Tranpkp