There are 2 tool/add-ins I install on any computer I will be doing MS Office VBA programming on: (i) Smart Indenter (ii) MZ-Tools.

I’m happy to announce that Carlos Quintero, the man behind MZ-Tools, has released a brand new version of MZ-Tools 8.0.  If you have never heard of MZ-Tools, I would urge you to take a look.  It will seriously aid you in the development process by putting powerful features (much more powerful Search/Find/Replace,  code library, Error Exception and so much more!) at your fingertips.

For an overview of some of the features  of MZ-Tools, check out http://www.mztools.com/v8/features.aspx or better yet, take it for a 30 day test drive.

On a side note, Carlos is giving a 50% reduction on the price of MZ-Tools for a short period of time to celebrate MZ-Tools 15th anniversary.  So if ever you were considering it, now’s the time.

I should also state that I have no affiliation with Carlos or this product.  This is simply my opinion.  I personally believe this to be an exceptional tool and have been using it for years now and couldn’t work without it!

Upgrading from a Prior Version

A nice thing to know is that, if you already have a prior version of MZ-Tools installed, you can install this new version without needing to uninstall your current version.  This permits you to keep the toolbar from the previous version, allowing you some time to get familiar with the new version’s toolbar and features.

Furthermore, I was pleased to see the installation routine asked to import my settings from my prior version, thus saving me the time of setting up my preferences (error handler, procedure header, module header, code library, …).