Commenting out code

[Guest]

Hi,

I know how to comment out code line by line

Is there a way to comment out multiple lines at once.

Like in C++ you can
use - "/*"
and - "*/"

Is there something in excel because I have a lot of code that has to be
commented out and I dont want to go line by line and click " ' ".

Thanks for your help.

 

[Ron de Bruin]

Hi Jeff

In the VBA editor right click on the menu bar and check Edit.
On this toolbar there are two buttons that you can use for the selected code

 

[Gord Dibben]

Jeff

In VBE Right-click on a toolbar then Customize>Commands>Edit.

Drag Comment Block and UnComment Block buttons to your Toolbar.


Gord Dibben MS Excel MVP