This is a list of some FREE tools I have used, and why I find them useful Sure you can do without these tools, but each of them can help you add some quality or speed to your project, so why not take advantage of these options when they are right there in front of you?
I will ONLY recommend tools I have used or are using, and at the moment only freeware/donationware tools.
This is a very useful tool for writing code faster, and reusing code snippets and templates. It has features to add error handling to your code. It makes it much easier to keep your code consistent.
MZ-Tools 3.0 is a freeware add-in for Visual Basic 6.0, Visual Basic 5.0 and the Visual Basic For Applications editor (provided by a VBA-enabled application such as those in Office 2000-2013 32-bit, except Office 64-bit) which adds many productivity features to the IDE.
MZ-Tools have alot of functions, but the ones I use and like are the templates for Module/procedure headers, and error handlers. It also has a function “Procedure Callers” that will conveniently list all the places in your code in which a function is called. (I don’t think this includes function calls from a controls controlsource)
The MZ-Tools also has a code review feature which will point out certain issues that could potentially become a problem. It is a nice way to improve the quality of your code.
MZ-Tools can offer alot more, but I haven’t yet tried all it. MZ-Tools is free and certainly worth giving a go, if you are serious about writing VBA code.
This is another tool for looking through your VBA code and spot potential pitfalls or performance enhancements.
If you want to gain a quick overview of potential errors you can use the TM VBA-Inspector. This Add-In let’s you browse the entire VBA code of an application for potential errors.
This will give you a very quick overview of places to make improvements. You can also set options on which type of errors you want to check for, or even exclude entire modules from the check. Note that these are recommendations and not as such rules set in stone. There are rules, and every rule has an exception. But I’ve found it very instructive to work with this tool, and it really helps me hone my skills, and improve code quality.