Office Tips and Hints Blog

Home Page

Host your Web site with PureHost!

Thursday, November 05, 2009 – Permalink –

Change Code to Comments

Fast solution

When you're testing procedures, you can temporarily convert a block of VBA code to comments that will be ignored during a trial run.

Doing so manually by inserting an apostrophe before each line of code can be a real chore.

To simplify this task,

Open any module in the Visual Basic Editor (VBE)
Choose View >Toolbars>Edit from the menu bar to display the Edit toolbar.
Select the lines of code that you want to turn into comments.
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.

[Edited entry from 10/27/2006]

See all Topics

Labels: Access, Excel, PowerPoint, Word

<Doug Klippert@ 3:39 AM

Comments: Post a Comment

Links to this post:

<$BlogBacklinkTitle$>: <$BlogBacklinkSnippet$>
posted by <$BlogBacklinkAuthor$> @ <$BlogBacklinkDateTime$>

Create a Link