Automatically Input Error Handling VBA

[santosm]

Hi All,
Is there any way to automatically make it so that error handling code gets put in by default?

Code: Select all

On Error Goto ErrHandler

ErrHandler:
msgbox err.description
resume next

Thanks,
Mark

[HansV]

MZ-Tools 3.0 is a free add-in for the Visual Basic Editor in all versions of MS Office except for the 64-bit version of Office 2010/2013. One of its features is that you can create a "template" for your procedures, complete with error handling.

[santosm]

Cool, I will check that out!

Thanks,
Mark

[Wendell]

For what it's worth, I highly recommend it as well - if you are doing a complex development with lots of VBA, I consider it essential. And it handles adding and removing line numbers to code which can be very helpful in debugging errors.

[santosm]

Thanks Wendell!