VBA Add-In to Automatically Insert Text into New Subs/Functions

[dch3]

I have a specific error handler that I use as the basis for all of my subs &
functions. I'm going FRACKING NUTS having to constantly copy and paste it
into new procedures.

Does anyone know of an Add-in that will automatically insert text when a new
procedure is added? I've downloaded MZTools for VBA but there's no way to
modify the built-in error handler that they supply.

 

[Tom van Stiphout]

On Thu, 31 Jul 2008 21:26:06 -0700, dch3

Of course MzTools supports this. Check the Options screen, Error
Handler tab.

-Tom.
Microsoft Access MVP

 

[dch3]

I know but I couldn't figure out how to change the statements that the Error
Handler automatically inserts.

 

[Klatuu]

If you have MZTools installed, you can use Help to find information on how to
customize the error handler.