Table of Contents
The IsError function in VBA is used for error handling, allowing developers to identify and handle errors in their code. To implement this function, one must first understand the syntax and purpose of the function. The IsError function checks whether a given value is an error and returns a Boolean value of True or False. This allows for conditional statements to be used to handle errors in the code. To use this function, the value being checked must be enclosed in parentheses after the function, such as IsError(value). By incorporating the IsError function in the code, developers can effectively handle errors and ensure the smooth functioning of their VBA programs.
Use IsError Function in VBA (With Example)
You can use the IsError function in VBA to check if a given cell contains an error value and return TRUE or FALSE as a result.
Here is one common way to use this function in practice:
Sub CheckIsError()
Dim i As Integer
For i = 2 To 11
Range("B" & i).Value = WorksheetFunction.IsError(Range("A" & i))
Next i
End Sub
This particular macro checks if each cell in the range A2:A11 is an error value and returns either TRUE or FALSE in the corresponding cell in the range B2:B11.
The following example shows how to use this syntax in practice.
Example: How to Use IsError Function in VBA
Suppose we have the following column of values in Excel:
Suppose we would like to check if each value in column A is an error value or not.
We can create the following macro to do so:
Sub CheckIsError()
Dim i As Integer
For i = 2 To 11
Range("B" & i).Value = WorksheetFunction.IsError(Range("A" & i))
Next i
End Sub
When we run this macro, we receive the following output:
The values in column B display either TRUE or FALSE to indicate whether or not the corresponding values in column A are error values.
Note that the following values all return TRUE in column B:
- #DIV/0!
- #VALUE!
- #NUM!
All other values return FALSE since they are not error values.
Note: You can find the complete documentation for the VBA IsError function .
Additional Resources
The following tutorials explain how to perform other common tasks in VBA: