I'm used to the fox and try am trying to write something decent in Excel with VBA. I'm desperate to find a way to replace my 15 year old default errorhandling (that I copied myself from someone who 15 years ago already had written it 15 years before).

Any untrapped error goes to that routine and lets me close my application gracefully. I add a message to my users "wishing them a very good day too", which I must say is received with mixed feelings at times.

I get the feeling that in VBA, there is nowhere I can call such an errorhanlder via the on error handler. And if I want to get the same kind of error handling, I would have to write errorhandling in each ean every procedure/sub and function.

Please tell me I've overloooked something.

Kind regards,

Marc