There is no event to capture, VBA On Error doesn't work like that. What you can do is write a wrapper for your RTD call wrappers-to-simplify-use - MS Lean. Be aware that not all errors may be communicated back to the VBA however