How to comment and uncomment blocks of code in the Office VBA Editor

Question

In the VBA editor of Office  ALT   F11   how do you comment or uncomment a block of code

User · Answer

Right-click on the toolbar and select Customize    Select the Commands tab  Under Categories click on Edit  then select Comment Block in the Commands listbox  Drag the Comment Block entry onto the Menu Bar  yep  the menu bar  Note  You should now see a new icon on the menu bar    Make sure that the new icon is highlighted  it will have a black square around it  then  click Modify Selection button on the Customize dialog box  An interesting menu will popup   Under name  add an ampersand   amp   to the beginning of the entry   So now instead of  Comment Block  it should read  amp Comment Block  Press Enter to save the change  Click on Modify Selection again and select Image and Text  Dismiss the Customize dialog box  Highlight any block of code and press Alt-C   Voila  Do the same thing for the Uncomment Block or  any other commands that you find yourself using often

User · Answer

An easy way to add buttons to Comment or Un-Comment a code block is    Go to View-Toolbars-Customise Select the Command tab Select the Edit Category on the left Drag the    Comment Block    and    Uncomment Block    icons onto your toolbar

User · Answer

After adding the icon to the toolbar and when modifying the selected icon  the ampersand in the name input is specifying that the next character is the character used along with Alt for the shortcut  Since you must select a display option from the Modify Selection drop down menu that includes displaying the text  you could also write  amp C in the name field and get the same result as  amp Comment Block  without the lengthy text

User · Answer

There is a built-in Edit toolbar in the VBA editor that has the Comment Block and Uncomment Block buttons by default  and other useful tools    If you right-click any toolbar or menu  or go to the View menu   Toolbars   you will see a list of available toolbars  above the  Customize     option   The Standard toolbar is selected by default  Select the Edit toolbar and the new toolbar will appear  with the Comment Block buttons in the middle      This is a simpler option to the ones mentioned

User · Answer

With MZ-Tools installed  I comment uncomment blocks in VBE by using the keyboard shortcut  Ctrl Alt C   MZ-Tools default

User · Answer

In the VBA editor  go to View  Toolbars  Customise    or right click on the tool bar and select Customise     Under the Commands tab  select the Edit menu on the left   Then approximately two thirds of the way down there s two icons  Comment Block and Uncomment Block   Drag and drop these onto your toolbar and then you have easy access to highlight a block of code  and comment it out and uncomment with the click of a button     See GauravSingh s answer if you want to assign keyboard shortcuts

User · Answer

Have you checked MZTools   It does a lot of cool stuff      If I m not wrong  one of the functionalities it offers is to set your own shortcuts

User · Answer

Or just click View  ToolBars  Edit  Then you can select a block of code and then click the Comment or Uncomment toolbar button to do everything in one click   As an aside  you can Tab Shift Tab a block of selected text also  When I was a noobie  I didn t know that for a long time and would do them one line at a time   Good Luck

User · Answer

Steps to comment   uncommented   Press alt   f11  Developer tab visual basic editor view tab - toolbar - edit - comments

[vba] How to comment and uncomment blocks of code in the Office VBA Editor

Examples related to vba

Examples related to comments