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>

 

[Jay Freedman]

Hi Ari,

Templates of this kind are a feature of MZ Tools for VBA, which I
highly recommend for this and dozens of other time-saving features.
Visit www.mztools.com.

--
Regards,
Jay Freedman
Microsoft Word MVP
Email cannot be acknowledged; please post all follow-ups to the
newsgroup so all may benefit.