Code Commenter and Error Handler Add-In

This content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.

Use the VBA Code Commenter and Error Handler to create code that is more professional and easier to debug. The Code Commenter portion of the tool can help you create well-commented code that is easier to maintain by automatically adding comments and headers to procedures using customizable templates (.eht files). You can use the Error Handler portion of the tool to simplify and automate the creation of standardized error handler code. The VBA Error Handler uses input dialog boxes that capture basic information and inserts standardized error handling code using a customizable template (.eht file).

To open the Code Commenter and Error Handler add-in, open the Visual Basic Editor (ALT + F11) from any Office application. If the Code Commenter and Error Handler tool is not listed in the Add-Ins menu, you must first load it, using the Add-In Manager located in the Add-Ins menu. When the tool is loaded, you can launch it from the Add-Ins menu. To load the Code Commenter and Error Handler add-in into the Add-In Manager, select the add-in, and then select the Loaded/Unloaded check box.

In This Section

• Main Dialog Box (Code Commenter and Error Handler)
  A single template inserts preformatted comment headers and error handler blocks into one or more procedures in a project.
• Select Code Commenter or Error Handler Templates Window (Code Commenter and Error Handler)
  This window makes it possible for you to select the file you wish to use as your template.
• Template Editor (Code Commenter and Error Handler)
  Manage and customize your template file.
• Code Commenter and Error Handler Template Formats
  The VBA Code Commenter and Error Handler add-in works by inserting text from a specified template into each procedure in the scope chosen by the user.

Related Sections

• Office Developer Productivity Tools
  A number of tools designed to aid in rapid application development in the Microsoft® Visual Basic® Editor are provided with Microsoft® Office XP Developer.
• Office Developer Productivity Tools Add-In Manager
  With the Add-In Manager, you can load any or all of the Microsoft® Office Developer productivity tools that you require, and have them appear in the Add-Ins menu.
• Multi-Code Import/Export Add-In
  Import and export Microsoft® Visual Basic® for Applications (VBA) objects from your project.
• VBA Source Control Add-In
  The VBA Source Control add-in provides check in/check out, versioning, history, and other important source code management functions for use in the Microsoft® Visual Basic® for Applications (VBA) environment.
• VBA String Editor
  Create strings quickly and easily, and in the proper syntax using the String Editor.