Page 1 of 4

1. Introduction
2. Ignoring Errors
3. Trapping errors on the next line
4. Error Handling for the whole procedure

Comments

1. DotNetGuts (DNG)
   07 Jan 2009 at 23:15
   For Error Handling in Asp.net you can read following article http://dotnetguts.blogspot.com/2007/10/error-handling-in-net-with-example.html
2. MathiasRav
   26 May 2004 at 05:25

   Sometimes, I use a module to take care of error handling:
   

   
   

   Code:

   Option Explicit
   

   
   Sub ErrHandl(Error As ErrObject)
      Dim S As String
      Dim D As Date
      Dim TimeS As String
      D = Now
      TimeS = "[" & FormatDateTime(D, vbShortDate) & " " & _
          FormatDateTime(D, vbLongTime) & "]"
      S = "Error occured. " & Error.Number & ": " & _
          Error.Description & _
          " (" & Error.Source & ")"
      Debug.Print TimeS & " " & S
   End Sub

   
   

   
   

   
   And then, in my form:
   

   
   

   Code:

   Sub xxx()
      On Error GoTo ErrHandl:
      -- Code --
      Exit Sub
   ErrHandl:
      ErrHandl Err
   End Sub

   
   

   
   Of course, the module can be optimized, but I don't make biig applications, so I just use Debug.Print

3. Sonic D Hedgehog
   27 Jul 2003 at 23:41

   Most people don't notice this, but if you have error-handling code at the end of a sub/function, you have to place Exit Sub or Exit Function before it, or it'll execute the error handler afterward even though nothing went wrong.

4. Marco A. Marrero
   10 Apr 2002 at 19:28

   Resume Next will execute the next statement, even if it's inside an IF statement. Worse of all, VB/VBscript evaluates the whole expression.
   

   
   Public Function test2()
   On Error Resume Next
      If (1 = 2) And ((1 / 0) = 5) Then
          MsgBox "Why?"
      Else
          MsgBox "Ok"
      End If
   End Function
   

   
   

5. Developer Fusion Bot
   01 Jan 1999 at 00:00

   This thread is for discussions of Error Handling.

James first started this website when learning Visual Basic back in 1999 whilst studying his GCSEs. The site grew steadily over the years while being run as a hobby - to a regular monthly audience ...