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

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.

Related Posts:

  1. What does <> mean?
  2. How to find a value in an excel column by vba code Cells.Find
  3. Check if a string contains another string
  4. VBScript to open a dialog to select a filepath
  5. Does VBA have Dictionary Structure?
  6. “Sub or Function not defined” when trying to run a VBA script in Outlook
  7. What is the function of FormulaR1C1?
  8. What exactly is the function of Application.CutCopyMode property in Excel
  9. VBA Excel – Insert row below with same format including borders and frames
  10. Deleting a file in VBA
  11. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  12. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  13. Pass arguments to Constructor in VBA
  14. How to install Date Picker form control in Excel 2016
  15. How to install Date Picker form control in Excel 2016
  16. How to fill color in a cell in VBA?
  17. Refreshing all the pivot tables in my excel workbook with a macro
  18. VBA: Run time error ’91’?
  19. Compare Dates in VBA
  20. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  21. ‘Cannot find DAO350.dll’ file error VB6
  22. Average in VBA in Excel
  23. VBA Excel “Compile error: Object Required”
  24. Choosing paper size (NOT DEFAULT sizes) in excel vba
  25. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  26. Paste Special error 1004 PasteSpecial method of Range class failed
  27. VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
  28. Cannot run the macro… the macro may not be available in this workbook
  29. What tools are available for managing/writing to WordPress? [closed]
  30. comment_post_ID 0 (cannot remove from dashboard)
  31. How to remove comment spam in WordPress
  32. get comments and get posts in loop
  33. Facebook comments box on front page
  34. How is comment spam received without a comments form?
  35. Does a reply to a wordpress comment notify the author of the comment?
  36. Link name in comments to Author page? Comment Author Meta in Comments?
  37. Linking comments from registered users to their profile pages
  38. How to enable reply on most-deeply-nested comments?
  39. Display comments on a comment page without form
  40. Get Comments: Direct link to specific comment + post title
  41. Get all commenters on a post
  42. How can I make Disqus comments not show up on pages?
  43. What filter/action hook can I use to add a few links to the admin comments page?
  44. How can I show comments in random order?
  45. Is there any way to override “break comments into pages” and “close comments for old posts” on certain posts, but not on others?
  46. migrate comments from old database to new database
  47. Toggle nested comments
  48. Is it possible to make wp insert last comment onto another page
  49. How to allow only Admins or Logged In Users to post links in comments?
  50. wp_insert_comment error. puzzled by date value
  51. Private replies for comments
  52. Custom Post Type loops and Disqus
  53. edit_comment capability for subscriber
  54. How to add attributes to the comment form tag?
  55. Yoast makes comment_reply_link function output plain link to comment instead of reply link
  56. Display User Role Next To Comment
  57. Same email for all comments
  58. Add custom field in comments form
  59. Ajax comment form submit on frontpage alerts success but no insertion
  60. Declaring in variables [closed]
  61. Commenting out unwated CSS/scripts in HTML with PHP
  62. How do I reply to comments from admin panel on a tablet PC?
  63. Disable comments for a user? [closed]
  64. Showing author page if user has no post
  65. Polls with respective comments?
  66. Enable nested comments in Theme
  67. Show comment number per author per day
  68. Hide comments and posts posted by other user
  69. get comments by current user inside page template
  70. Send a mail to specific address in a custom field when a new comment is made on a specific post
  71. Keep comments but turn off commenting
  72. Where are comment ratings stored?
  73. how to SELECT for the current post id?
  74. Multisite WP-API json v2 : can i fetch all comments on all sites with a single query?
  75. How to save comment name email url fields?
  76. How to display the user’s comment status on the front end
  77. get_comments_number() vs. get_post_field( ‘comment_count’, ID )
  78. Comments turned off, but ‘Leave a reply’ link still there [duplicate]
  79. How to output number of comments with link to comments
  80. How do I make Twenty Ten display comments on the home page?
  81. How to get post id of last approved comment?
  82. action wp_set_comment_status never gets fired when i change the comment status [closed]
  83. Send email on new comment when no admin approval needed?
  84. Display WordPress comments before the plugins?
  85. Sort post comments from newest to oldest in pagination
  86. Merge get_comments & get_posts into a single query
  87. Using Disqus with headless WordPress setup?
  88. Attaching author tag to the comment
  89. AddThis Plugin adding html comments in P tags
  90. How to show a “Comments Are Closed” message on posts where comments have been closed?
  91. Comments pagination on author page
  92. Make custom WordPress comments list
  93. Stop theme displaying comments
  94. Custom Nested WordPress Comments with avatar
  95. How can I have a full comments.php for an easy editing of all its aspects?
  96. Transfer comments from one domain to another
  97. WordPress is adding above html
  98. Display DISQUS on homepage
  99. Customize the new comment notifications sent to the post author after the comment is approved
  100. Get approved comments or comments that the author is me

Leave a Comment