Join OfficeTipsAndMethods

Have some suggestions to share with the world?

Join OfficeTipsAndMethods and share your insight in a Comment. You must be a member to comment and all comments are moderated before being published. Membership is free and we would never share your personal information with anyone.

Become an OTM Member

Log In

YouTube Video Channel
Article Categories

Tools for the VBA Developer

Thomas Möller of Team-Moeller has very kindly given permission to publish this commented  list of VBA development tools.


Tool-Name: TM VBA-Inspector

Author: Thomas Möller


Purpose: Examine VBA-Code to find hidden faults and bad coding styles


Add. Info: For additional information refer to the help file and

this post on the Access Team Blog:


 Tool-Name: MZ-Tools 3.0 for VBA

Author: Carlos J. Quintero


Purpose: Great number of functions to make coding easier


Add. Info: You can attach a function to a shortcut

Options dialog / Shortcuts / Add "Search" to CTRL+F


Add. Info: You can easily rename a variable or a procedure:

  • Double click in variable name

  • Start Find-Dialog (CTRL + F) / Start search

  • Insert new name

  • Select each item and hit "Replace"

Tool-Name: VBE Tools v2.0

Author: Office Automation Ltd


Purpose: Bigger ‘Location’ label in References dialog


Add. Info: Start the options dialog. Check "Resize ‘Location Label’

on Tools / References dialog"


Tool-Name: Smart Indenter v3.5

Author: Office Automation Ltd


Purpose: Indent the whole code in a procedure, in a module or

in the whole project with one mouse click


Add. Info: Have a look at the options dialog. It shows directly

how the chosen options will indent your VBA-Code


 Tool-Name: TM VBA-ToDoFinder

Author: Thomas Möller


Purpose: Find ToDo’s in your VBA-Code


Add. Info: Tool and website is available only in German language

(But there is less UI – so check it out)


Add. Info: Put your ToDo’s as a comment to your VBA-Code

For example: ‘ToDo: Optimize this loop

Start ToDo-Finder and hit the Refresh-Button



 Tool-Name: Procbrowser

Author: Sascha Trowitzsch


Purpose: Browse through the procedures of a code-module


Add. Info: You find the button for download at the end of the website


Add. Info: Start the tool: Add-Ins / Procbrowser

Change the language: Context menu / "Sprache" / "Englisch"

Comments are closed.