SyntaxFix

Write A Post

Hire A Developer

Questions

Tags

[excel] Does VBA contain a comment block syntax?

In VBA is there a short way to comment out a block of code the same way java uses /*...*/?

This question is related to excel vba ms-access outlook word

The answer is

There is no syntax for block quote in VBA. The work around is to use the button to quickly block or unblock multiple lines of code.

prefix the comment with a single-quote. there is no need for an "end" tag.

'this is a comment

Extend to multiple lines using the line-continuation character, _:

'this is a multi-line _
   comment

This is an option in the toolbar to select a line(s) of code and comment/uncomment:

enter image description here

Source: Stackoverflow.com

Examples related to excel

• Python: Pandas pd.read_excel giving ImportError: Install xlrd >= 0.9.0 for Excel support • Converting unix time into date-time via excel • How to increment a letter N times per iteration and store in an array? • 'Microsoft.ACE.OLEDB.16.0' provider is not registered on the local machine. (System.Data) • How to import an Excel file into SQL Server? • Copy filtered data to another sheet using VBA • Better way to find last used row • Could pandas use column as index? • Check if a value is in an array or not with Excel VBA • How to sort dates from Oldest to Newest in Excel?

Examples related to vba

• Copy filtered data to another sheet using VBA • Better way to find last used row • Check if a value is in an array or not with Excel VBA • Creating an Array from a Range in VBA • Excel: macro to export worksheet as CSV file without leaving my current Excel sheet • VBA: Convert Text to Number • What's the difference between "end" and "exit sub" in VBA? • Rename Excel Sheet with VBA Macro • Extract Data from PDF and Add to Worksheet • Quicker way to get all unique values of a column in VBA?

Examples related to ms-access

• How to get parameter value for date/time column from empty MaskedTextBox • Access And/Or exclusions • Get length of array? • How to pass an array to a function in VBA? • How to insert values into the database table using VBA in MS access • Access 2013 - Cannot open a database created with a previous version of your application • Does VBA contain a comment block syntax? • java.lang.ClassNotFoundException: sun.jdbc.odbc.JdbcOdbcDriver Exception occurring. Why? • Manipulating an Access database from Java without ODBC • How to find longest string in the table column data

Examples related to outlook

• Does VBA contain a comment block syntax? • "Sub or Function not defined" when trying to run a VBA script in Outlook • Change HTML email body font type and size in VBA • css padding is not working in outlook • Image style height and width not taken in outlook mails • Paste Excel range in Outlook • MS Access VBA: Sending an email through Outlook • HTML email in outlook table width issue - content is wider than the specified table width • Save attachments to a folder and rename them • Sending email from Command-line via outlook without having to click send

Examples related to word

• Does VBA contain a comment block syntax? • Count frequency of words in a list and sort by frequency • Regular expression to match a word or its prefix