ErrObject.Clear Method (Microsoft.VisualBasic)

Examples

This example uses the Err object's Clear method to reset the numeric properties of the Err object to zero and its string properties to zero-length strings. Without the call to Clear , the second call to MsgBox would display the same error message.


   Sub ClearErr()
  ' Produce overflow error
  On Error Resume Next
  Dim zero As Integer = 0
  Dim result As Integer = 8 / zero
  MsgBox(Err.Description)
  Err.Clear()
  MsgBox(Err.Description)
End Sub
   
    Remarks
   
   
    Use
    
     Clear
    
    to explicitly clear the
    
     Err
    
    object after an error has been handled, such as when you use deferred error handling with
    
     On Error Resume Next
    
    . The
    
     Clear
    
    method is called automatically whenever any of the following statements executes:
   
   
    
     Any type of
     
      Resume
     
     statement
    
   
   
    
     
      Exit Sub
     
     ,
     
      Exit Function
     
     , or
     
      Exit Property
     
    
   
   
    
     Any
     
      On Error
     
     statement
    
   
   
    
     Any
     
      Try...Catch...Finally
     
     statement
    
    
     The
     
      On Error Resume Next
     
     construct may be preferable to
     
      On Error GoTo
     
     when handling errors generated during access to other objects. Checking
     
      Err
     
     after each interaction with an object removes ambiguity about which object was accessed by the code: You can be sure which object placed the error code in
     
      Err.Number
     
     , as well as which object originally generated the error (the object specified in
     
      Err.Source
     
     ).

推荐文章

大鼻子的鸡蛋 · 蕨型叶分形_纯代码创建蕨形叶分形matlab-CSDN博客

6 月前

有情有义的啄木鸟 · MS Access DB 前端 SQL Server 后端在表迁移后无法作为新记录打开任何表格

1 年前

豪气的瀑布 · python contains 多个关键字_Pandas str.contains-在字符串中搜索多个值并在新列中打印这些值..._梨花与虎的博客-CSDN博客

1 年前

沉着的米饭 · EPPLUS excel新增数据保存失败？ - 问答 - 腾讯云开发者社区-腾讯云

1 年前