Product Reviews

Best Practices for VBA Shops

Total Visual Code Tools makes it easier to write consistent code

If you write VB or VBA code for a living, you know there are a lot of annoying repetitive tasks in the job. (Of course, the same is true for almost any language). Total Visual Code Tools is designed to dispose of some of these annoyances, and to help enforce coding standards on multi-developer projects as well. It provides a set of builders and clean-up tools that work in Office 2000, Office XP, and VB 6.0.

After telling TVCT about your coding standards (the prefixes you use for variables, the commenting style you prefer, the way you like your error handlers structured and so on), you're ready to start using the Builders. These dialog boxes can create common code structures for you: procedures, properties, recordset code, SELECT CASE statements, and so on. Launch a builder, fill in some options (like the procedure name), click a button and watch the finished code get injected directly into your project (or, if you prefer, to the clipboard, a file, or a text editor).

TVCT also offers tools to clean up and standardize existing code, to obfuscate code that you're ready to ship, and to manage a few other little tasks such as block-commenting code or clearing the immediate window.

All of the standards you set up are stored in a single external file, which makes it easy to make sure everyone on a project is using the same standards. Another bonus for the busy shop is a help file section that details a bunch of VBA best practices.

One of the differences between good developers and those who just hack at the code is the tools that they use. Adding Total Visual Code Tools to your own toolset will help you to write more consistent code -- which will pay off in the long run as you discover that consistent code is easier to maintain.

About the Author

Mike Gunderloy, MCSE, MCSD, MCDBA, is a former MCP columnist and the author of numerous development books.


  • Basic Authentication Extended to 2H 2021 for Exchange Online Users

    Microsoft is now planning to disable Basic Authentication use with its Exchange Online service sometime in the "second half of 2021," according to a Friday announcement.

  • Microsoft Offers Endpoint Configuration Manager Advice for Keeping Remote Clients Patched

    Microsoft this week offered advice for organizations using Microsoft Endpoint Configuration Manager with remote Windows systems that need to get patched, and it also announced Update 2002.

  • Azure Edge Zones Hit Preview

    Azure Edge Zones, a new edge computing technology from Microsoft designed to enable new scenarios for developers and partners, emerged as a preview release this week.

  • Microsoft Shifts 2020 Events To Be Online Only

    Microsoft is shifting its big events this year to be online only, including Ignite 2020.

comments powered by Disqus

Office 365 Watch

Sign up for our newsletter.

Terms and Privacy Policy consent

I agree to this site's Privacy Policy.