View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Frederick Chow Frederick Chow is offline
external usenet poster
 
Posts: 75
Default Can I place "On Error GOTO xxx" into module level?

Hi all,

Just have a question.

I have developed so many subroutines in many modules of a workbook,
including an error handling procedure which handles any unhandled errors..
Instead of writing an error-handling routine within all subroutines, is it
possible to write an error-handling routines once in a workbook so as to
apply to all other subroutines?

By the way, is there a syntax something like "On Error GoTo <Subroutine" or
"On Error GoSub ... " in VBA?

Thanks a lot.

Frederick Chow