VBA Debugging ToolsThis content is no longer actively maintained. It is provided as is, for anyone who may still be using these technologies, with no warranties or claims of accuracy with regard to the most recent product version or service release.
Microsoft® Visual Basic® for Applications (VBA) and the Visual Basic Editor contain many tools you can use to help debug your code. Some of the tools are available when you are actually writing your code; these are known as design-time tools. Other tools are used when your code is running; these are known as run-time tools, and they let you break into, examine, and step through running code to determine what is happening. Experienced Office developers use all of these tools at one time or another in the development process.
For more information about any of the specific debugging tools, search the Visual Basic for Applications Reference Help index for the name of the tool.