ISERROR

ISERROR(expression)

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


expressionThe 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

© 2024 Better Solutions Limited. All Rights Reserved. © 2024 Better Solutions Limited Top