function and sub templates

[Ari]

I'm not aware if this is possible but:
when you type in a module
sub thename


vba will complete it by:


sub cmdFinish()


end sub


Is there a way to edit the template it uses for this? I would like it
to create my error handler and add:


cmdFinish_error:
MsgBox "There was an error, please check the Debug Log"
Call addMessage("Error in cmdFinish in frmSelectFields_two Err: " &

Err.Number, Err.Description)


so it comes out as


sub cmdFinish()
cmdFinish_error:
MsgBox "There was an error, please check the Debug Log"
Call addMessage("Error in cmdFinish in frmSelectFields_two Err: " &

Err.Number, Err.Description)
end sub


when I type sub cmdFinish <enter>

 

[Steve Rindsberg]

You can't change this, but have a look at MZTools ( www.mztools.com )
It's a set of addins for VB/VBA et al that let you add your own error handler
code, comment blocks and lots of other goodies with one extra click.

Great stuff, and it's free.