Edit toolbar
You'll many times want to change blocks of code to comments in VBA modules; temporarily convert a block of VBA code to comments so that it's ignored during a trial run. Inserting an apostrophe before each line of code is a bother. Office 2000+ simplifies this task by letting you convert a block of code to comments with a click of a button.
Open any module in the Visual Basic Editor (VBE), and then choose
View>Toolbars and choose
Edit from the menu bar to display the
Edit toolbar.
Select the lines of code that you want to turn into comments. Then, click the
Comment Block button on the
Edit toolbar (it's the sixth button in from the RIGHT end of the toolbar).
Each line of the selected code is now preceded with an apostrophe.
To convert the comments back to executable code, select the appropriate lines and click the
Uncomment Block button, which is immediately to the right of the
Comment Block button.
This, of course, works in any application that uses the VBE.
It's been suggested that two or three apostrophes (sometimes called inverted commas) be placed around existing comments. When the Comment Block is used, the original comments will not be removed.
See all Topics