sub and function templates

[Kooshesh]

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>

 

[Douglas J Steele]

If you're using Access 2000 or newer, take a look at MZTools
http://www.mztools.com/

 

[David C. Holley]

Not in a manner that is native to Access, but google MZ-Tools. You'll
find it most useful and I believe that it does support templates.

 

[Kooshesh]

wow It works good