ISERROR

ISERROR(expression)

Returns the value True or False depending if the expression is an error (Boolean).

expression

The expression to test.

REMARKS

* Error values can be explicitly created using the CVErr() function.
* You can use the CVERR function to return a specific type of error.
* You can use the ERROR Function to return the error message corresponding to a given error number.
* You can use the ERROR Statement to generate an error.
* You can use the ISARRAY function to return True or False depending if the value is an array.
* You can use the ISDATE function to return True or False depending if the value is a date.
* You can use the ISEMPTY function to return True or False depending if the variable has been initialised.
* You can use the ISMISSING function to return True or False depending if an optional argument has been passed in.
* You can use the ISNULL function to return True or False depending if the value contains no data.
* You can use the ISNUMERIC function to return True or False depending if the value is a number.
* You can use the ISOBJECT function to return True or False depending if the variable represents an object.
* The equivalent .NET function is [[Microsoft.VisualBasic.Information.IsError]]
* For the Microsoft documentation refer to learn.microsoft.com

Debug.Print IsError(CVErr(6))    '= True  
Debug.Print IsError(CVErr(11))   '= True  
Debug.Print IsError(CVErr(55))   '= True  
Debug.Print IsError(Error(6))    '= False  
Debug.Print IsError(CVErr(-100)) ' generates an Invalid Procedure Call or Argument run-time error  
Debug.Print IsError(10/ 0)       ' generates a Division by Zero run-time error  

Private Sub MyProcedure(Optional ByVal vVariant As Variant) 
   If IsError(vVariant) Then 
   End If 
End Sub