Hey all,
I consider myself an advanced programmer - my one downfall being error checking. I know it's a pretty important topic - so I'm looking to improve. I use error checking often, but not all the time. If I see the potential for a problem I'll typically throw an on error goto err statement in and a label at the end of the sub with a messagebox specifying error number and name. That's not always sufficient though.

I recently saw a forum talking about using the on error resume next statement and then checking the err object in the following statement for problems. I also am interested in getting a line numbering add on and specifying the line number in the message box.

The problem with the second method is that I'm really not handling any errors, just passing the information on to the user. I need some good techniques for handling errors. I don't want to go too crazy anticipating every error (such as a data type conversion error), but I want to make sure I'm thorough.

If I get some good responses, I'd recommend stickying this thread - it'd be very useful for everyone.