Looking to save time coding and designing all while improving the quality of your code? Let me introduce my two favorite VBA development add-ons (each work in both Excel and Project VBA editor):
Note: Both tools are freeware.
What They Do
Smart Indenter: Rebuilds (or builds) indentation for procedure, modules, or an entire project. The utility allows you to set your own indentation preferences in a dialog box, and allows you to view the sample output before applying the formatting to your project.
If you hate formatting code (like I do) this is your solution. Also, your co-workers will love you: indenting your code in a consistent manner helps improve readability.
MZTools: If you want to:
- Find code faster
- Code faster
- Design faster
- Generate documentation for your projects
- Ensure the quality of your work
- Enhance your VB / VBA experience
Then this tool is for you. Some of my favorite features include:
- Code Templates - Save procedures you use frequently and access them on the fly.
- Add Procedure/Module Headers: Insert procedure/module headers based on your preferences. Options to include variables exist as well (e.g. inserts date procedure created, procedure author, etc. in header)
- Line Numbering - Inserts line numbers along the gutter of your code. Great for integrating with error handling.
- Error Handler - Add an error handler to a procedure with a customizable template. If the procedure body is not empty the tool merges the error handler with the procedure code.
- Select Case/Msgbox Assistant - 2 great features that let you quickly build Message Boxes and Case statements.
No comments:
Post a Comment