 vbWatchdog gives you complete control over error handling inside your VBA projects. | By adding vbWatchdog to your VBA projects, you gain the ability to specify a custom VBA procedure that will be called instantly when errors occur anywhere in your VBA code – we call this procedure your global error trap. From within your global error trap, you can gather detailed information about the error that occurred (typically for logging purposes and/or displaying an error dialog). For example, you can programmatically:  Determine the context of the error (for example, whether or not it is an unhandled error) Query and log the internal VBA callstack (to identify the source procedure and module of error) Read and log the live values of all local variables in the callstack Detect and log the exact line of code that caused the failure Display a professional customizable error dialog What's more, with vbWatchdog there are no DLL files to distribute to your end-users. Everything is contained within class modules that you add directly to your projects. The product is licenced on a per-developer basis (starting from as little as GBP £70 per developer). Supports all editions of VBA6 and VBA7 (that's from Office 2000 to 2013, including 64 bit editions)  More info + Pricing Installation + Getting Started Guide Getting Started Videos BUY NOW |
Key benefits Allows you to identify the source procedure and module name where the error occurred List the exact line number to identify the line of code that failed Report the full callstack that led up to the exception Allows local error handling to co-exist with your global error handler Choose to either handle the error globally, or just use it as an error-tracing tool You have a customizable error dialog at your fingertips (inc. debug options) No third-party DLLs required - vbWatchdog is coded neatly inside your VBA environment Detailed online manual Getting Started Sample.MDB 14 day money back guarantee Advanced features (Enterprise Edition only) List values of variables within each procedure on the callstack A Try-Catch paradigm for simplifying local error handling LiveCallstack object that can be used outside of your global handler Prevents the Access Runtime from closing on unhandled VBA errors Price This product is licensed on a per-developer basis. Standard Edition GBP £70 ($115/€85) for a single developer licence. Enterprise Edition GBP £85 ($140/€105) for a single developer licence.  (more purchasing options shown on next page) Requirements Any Microsoft Office VBA host application Supports VBA6 and VBA7 (that's Office 2000 to the latest Office 2013) Supports both 32 bit and 64 bit editions of Office Also supports all special editions such as the Access Runtime environment. 
The vbWatchdog customizable dialog in action! | 