Mark Simms
marksimms at verizon.net
Wed Aug 17 14:53:40 CDT 2011
Interesting subject. I remember debugging an Excel VBA addin. I discovered that if you didn't trap errors in a form's Initialize event, Excel just "bugged-out".....completely...when an error occurred there. No error message, nothing. This was back in the 2003 release. > > I'm in your camp (I think) on error handling. > > In development phase, I only use errorhandling when it is required for > the logic (like back in the VB6 days, before collections had > .Contains), > or when there was a situation that I can't program around to prevent > errors. (like if I am dividing by x, I can verify beforehand that x is > not zero...but if I am sending a command to a database, and that > command > might fail, the only way to catch it is with errorhandling). > > Now most of my finished stuff has errorhandling through out, depending > on the system, the platform and the processes. > > Drew