Results 1 to 2 of 2

Thread: Error handling

  1. #1

    Thread Starter
    Addicted Member Fonty's Avatar
    Join Date
    May 2006
    Location
    New York
    Posts
    173

    Error handling

    Is it enough to insert the On Error GoTo XXXXX procedure at the begining of every sub, in order to trigger XXXXX whenever an error occurs?

  2. #2
    Fanatic Member Dnereb's Avatar
    Join Date
    Aug 2005
    Location
    Netherlands
    Posts
    863

    Re: Error handling

    If XXXXX is A label somwhee in your code... Yes.

    But todo Propper Error handling use an area at the end of exch sub/function to handle the expected errors en display an error message if the error was unexpected or critical for your programn flow.

    To speed up this process you can download M-Z tools for VBA (free)
    to generate the basic error handling code.
    why can't programmers keep and 31 Oct and 25 dec apart. Why Rating is Useful
    for every question you ask provide an answer on another thread.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width