Share via


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

  • 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.