ErrorHandler question

[tgmoon]

I have a whole load of little subs in a modules.... eg

Sub WM1()
On Error Goto ErrorHandler
my code
Exit Sub

ErrorHandler:
MsgBox "Error"
End Sub.

What I was wondering is if it is possible to have a single ErrorHandler that encompases the whole module?

 

[EBGreen]

You can write an error handling sub then in each sub in the module, have the ErrorHandler code call the sub that you created to handle errors.

[red]"... isn't sanity really just a one trick pony anyway?! I mean, all you get is one trick, rational thinking, but when you are good and crazy, oooh, oooh, oooh, the sky is the limit!" - The Tick[/red]