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. Is there a way to create multiline comments in Python?
  30. Is it bad practice to comment out single lines of CSS with //?
  31. Can comments be used in JSON?
  32. Can comments be used in JSON?
  33. How do I comment out a block of tags in XML?
  34. Is there a way to convert all comments into javadoc comments? [Eclipse/Java]
  35. How do I comment out a block of tags in XML?
  36. How do you do block comments in YAML?
  37. Can comments be used in JSON?
  38. How do you comment out code in PowerShell?
  39. Comments in Markdown
  40. Comments in Markdown
  41. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  42. Visual Studio /**/ comment shortcut?
  43. How to “comment-out” (add comment) in a batch/cmd?
  44. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  45. Object Required Error in excel VBA
  46. What are .NumberFormat Options In Excel VBA?
  47. Is ‘# -*- coding: utf-8 -*-‘ also a comment in Python?
  48. Better way to find last used row
  49. VBA, if a string contains a certain letter
  50. Excel VBA Macro: User Defined Type Not Defined
  51. lists and arrays in VBA
  52. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  53. Select method of Range class failed via VBA
  54. How to add comments into a Xaml file in WPF?
  55. Does VBA contain a comment block syntax?
  56. Is it possible to have a multi-line comments in R?
  57. What is the common header format of Python files?
  58. Why does “Paste Method of Worksheet class failed” occasionally occur?
  59. How to “comment-out” (add comment) in a batch/cmd?
  60. How to return a result from a VBA function
  61. How to clear memory to prevent “out of memory error” in excel vba?
  62. Use VBA to Clear Immediate Window?
  63. Multi-Line Comments in Ruby?
  64. VBA: Else without If Error
  65. Recommended IDE for VBA
  66. ByRef argument type mismatch in Excel VBA
  67. How to write a comment in a Razor view?
  68. How to write an inline-comment in Python
  69. VBA: Convert Text to Number
  70. VBA Error: “Compile error: Expected End Sub”
  71. Scraping data from website using vba
  72. Error: “Could Not Find Installable ISAM”
  73. Loop without Do error
  74. R: Comment out block of code
  75. Row count where data exists
  76. VBA array sort function?
  77. What’s a quick way to comment/uncomment lines in Vim?
  78. Test or check if sheet exists
  79. How to detect if user select cancel InputBox VBA Excel
  80. macro run-time error ‘9’: subscript out of range
  81. single line comment in HTML
  82. How to Clear Office Clipboard with VBA
  83. Why does my VBA code throw an “Invalid outside procedure” error?
  84. Details of difference between @see and @inheritDoc
  85. Excel Solver Password: what is it and where can it be acquired/bought?
  86. Using Excel VBA to run SQL query
  87. Compile error: Next without For || VBA
  88. Is there a way to crack the password on an Excel VBA Project?
  89. Multi-Line Comments in Ruby?
  90. How to change “Leave a Reply” title in wordpress twentyfifteen theme
  91. Where can I find the “Leave a Reply” line in the WordPress SmartBiz.1.1.1 theme?
  92. Show comments on WordPress home page
  93. Why do I get comment spam even with Akismet and Captcha?
  94. Is there ANY way to remove comments function and section totally?
  95. What tools are available for managing/writing to WordPress? [closed]
  96. How to rearrange fields in comment_form()
  97. setting comments off as default for pages and custom post types?
  98. how to reduce the number of spam comments
  99. Is it possible to pull comments from facebook into your blog?
  100. Find out which moderator approved comment?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)