Does VBA contain a comment block syntax?

Although there isn’t a syntax, you can still get close by using the built-in block comment buttons:

If you’re not viewing the Edit toolbar already, right-click on the toolbar and enable the Edit toolbar:

Then, select a block of code and hit the “Comment Block” button; or if it’s already commented out, use the “Uncomment Block” button:

Fast and easy!

Related Posts:

  1. Error: “Could Not Find Installable ISAM”
  2. Object Required Error in excel VBA
  3. What are .NumberFormat Options In Excel VBA?
  4. Better way to find last used row
  5. VBA, if a string contains a certain letter
  6. Excel VBA Macro: User Defined Type Not Defined
  7. VBA Runtime Error 1004 “Application-defined or Object-defined error” when Selecting Range
  8. Select method of Range class failed via VBA
  9. Why does “Paste Method of Worksheet class failed” occasionally occur?
  10. How to return a result from a VBA function
  11. How to clear memory to prevent “out of memory error” in excel vba?
  12. Use VBA to Clear Immediate Window?
  13. VBA: Else without If Error
  14. Recommended IDE for VBA
  15. ByRef argument type mismatch in Excel VBA
  16. VBA: Convert Text to Number
  17. VBA Error: “Compile error: Expected End Sub”
  18. Loop without Do error
  19. Row count where data exists
  20. Test or check if sheet exists
  21. How to detect if user select cancel InputBox VBA Excel
  22. macro run-time error ‘9’: subscript out of range
  23. Why does my VBA code throw an “Invalid outside procedure” error?
  24. Excel Solver Password: what is it and where can it be acquired/bought?
  25. Compile error: Next without For || VBA
  26. Is there a way to crack the password on an Excel VBA Project?
  27. MS Excel Scatterplot converts Months to Numbers
  28. What does <> mean?
  29. Excel to Google Sheets – Error: Formula parse error
  30. Swap x and y axis without manually swapping values
  31. Excel: Calculate the frequency of a particular month in a column of date cells
  32. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  33. How to find a value in an excel column by vba code Cells.Find
  34. How to use Regular Expressions (Regex) in Microsoft Excel both in-cell and loops
  35. Insert picture into Excel cell
  36. What is a correct MIME type for .docx, .pptx, etc.?
  37. Is there Infinity in Spreadsheets?
  38. Declaring variables in Excel Cells
  39. How to loop in excel without VBA or macros?
  40. “Sub or Function not defined” when trying to run a VBA script in Outlook
  41. What is correct content-type for excel files?
  42. How do I get countifs to select all non-blank cells in Excel?
  43. What is the function of FormulaR1C1?
  44. What exactly is the function of Application.CutCopyMode property in Excel
  45. Excel – SUMIFS for multiple columns
  46. Workaround for “Formula omits adjacent cells”
  47. VBA Excel – Insert row below with same format including borders and frames
  48. check if a file is open in Python
  49. Select all the cells below current cell in excel
  50. Excel: Can I create a Conditional Formula based on the Color of a Cell?
  51. Excel VBA: Can’t get a match, error “Unable to get the Match property of the WorksheetFunction class”
  52. Run-time error ‘3061’. Too few parameters. Expected 1. (Access 2007)
  53. How do I open space-delimited file in Microsoft Excel?
  54. Scraping data from website using vba
  55. Using SUBSTITUTE with wildcard characters
  56. Change default ‘delimiters’ in excel
  57. Adding a newline character within a cell (CSV)
  58. VB: Error loading type library/DLL. (Exception from HRESULT: 0x80029C4A (TYPE_E_CANTLOADLIBRARY)
  59. How to install Date Picker form control in Excel 2016
  60. How to install Date Picker form control in Excel 2016
  61. How to fill color in a cell in VBA?
  62. (Excel) Conditional Formatting based on Adjacent Cell Value
  63. Shortcut to Apply a Formula to an Entire Column in Excel
  64. Refreshing all the pivot tables in my excel workbook with a macro
  65. How to label scatterplot points by name?
  66. What is the difference between “Form Controls” and “ActiveX Control” in Excel 2010?
  67. Average in VBA in Excel
  68. VBA Excel “Compile error: Object Required”
  69. Choosing paper size (NOT DEFAULT sizes) in excel vba
  70. “Unable to get the VLookup property of the WorksheetFunction Class” error [duplicate]
  71. Paste Special error 1004 PasteSpecial method of Range class failed
  72. Using Excel VBA to run SQL query
  73. VBA: Getting run-time 1004: Method ‘Range’ of object ‘_Worksheet’ failed when using cells
  74. Cannot run the macro… the macro may not be available in this workbook
  75. Substring in excel
  76. IndexError: too many indices for array
  77. IndexError: too many indices for array
  78. ‘Microsoft.ACE.OLEDB.12.0’ provider is not registered on the local machine
  79. IndexError: too many indices for array
  80. Why do we need “Relationships” between tables at all?
  81. Looking for a clear description of Excel’s .xlsx XML format
  82. Help needed with Median If in Excel
  83. Invalid column count in CSV input on line 1 Error
  84. Invalid column count in CSV input on line 1 Error
  85. How do you trouble shoot a “Data type mismatch in criteria expression” error in MS Access 2010?
  86. What Excel formula returns the sheet name?
  87. Regular expression to match a word or its prefix
  88. excel IF formula Error, “You’ve entered too many arguments”
  89. What does it mean by word size in computer?
  90. Check if a string contains another string
  91. Export html table data to Excel using JavaScript / JQuery is not working properly in chrome browser
  92. VBScript to open a dialog to select a filepath
  93. How to fix file format and extension don’t match?
  94. What’s the size of a QWORD on a 64-bit machine?
  95. Does VBA have Dictionary Structure?
  96. MS Access error: relationships must be on same number of fields with the same data types
  97. How can I open an Excel file in Python?
  98. ValueError: cannot index with vector containing NA / NaN values
  99. How to SUM two fields within an SQL query
  100. How can I import an Excel file into SQL Server?

Leave a Comment

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