Does VBA contain a comment block syntax? [duplicat

问题:

This question already has an answer here:

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

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

回答1:

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!

回答2:

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:

回答3:

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.