Here are some links to free VBA or UI development tools for MS Office. I've posted previously about tools for Outlook, so check out the post called Spotlight: Free Outlook Productivity Tools for more information.
I haven't yet tried most of these so I'd be curious to hear any feedback about your experience with them. The VBE Tools add-in looks the most useful for me.
1: Access 2007 Developer Ribbon
On Utter Access someone posted a tool for developers using Access 2007. Visit Developer's Ribbon to download a copy.
2: VBE Tools
Stephen Bullen's Excel website has several add-in tools available to enhance your programming experience, and VBE Tools is no exception. VBE Tools is available for Office 2000-2003.
3: MZ Tools
From the MZ-Tools website:
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-2007) which adds several productivity features to the IDE.
MZ-Tools is very easy to use. It provides a main menu, a toolbar, handy context menus and customizable shortcuts to access its features, which are detailed in the Features section.
You can customize several features of MZ-Tools to meet your development standards (data type prefixes, template for procedure headers, template for error handler, etc.) or your personal preferences (user name, shortcuts, etc.)
For your convenience, MZ-Tools has been localized in the following languages: English, Spanish, French, Italian, German and Portuguese (Portugal).
4: Smart Indenter and VB6 mouse fix
In VBA Tips, Tricks and Best Practices, Part Two of Four I mentioned these two VB IDE enhancements. Visit that post for links to get both.
Know any more development tools? Use one of these and have feedback?
About JP
4 Comments:
Don't forget Rob Bovey's Code Cleaner (http://appspro.com/Utilities/CodeCleaner.htm). It exports and removes all the code modules from your project, then adds them back. This removes all the compilation garbage code that piles up during development. The cleaned code may use less disk space, but more important, it loads faster and doesn't experience irregularities due to this junk in your VB project.
Don't forget Andy Pope's nice utility:http://www.andypope.info/vba/ribboneditor.htm
Stephen Bullen's terrific VBE Tools work fine in Office 2007 and 2010 too.
Unfortunately, if you chose to install 64 bit Office 2010, none of the com addins which were built using vb6 will work. This includes the VBE tools and the code cleaner.