How to use IsArray function in VBA?

The IsArray function in VBA (Visual Basic for Applications) is used to determine whether a variable is an array. It returns a Boolean value: True if the variable is an array; otherwise, it returns False.

Here’s how you can use the IsArray function:

Basic Usage


Sub CheckIfArray()
    Dim notArray As Integer
    Dim isArray As Variant
    notArray = 10
    isArray = Array(1, 2, 3, 4, 5)
    ' Check if notArray is an array
    If IsArray(notArray) Then
        MsgBox "notArray is an array"
        MsgBox "notArray is not an array"
    End If
    ' Check if isArray is an array
    If IsArray(isArray) Then
        MsgBox "isArray is an array"
        MsgBox "isArray is not an array"
    End If
End Sub

If you run this code, you’ll see two message boxes. The first one will tell you that notArray is not an array, and the second one will tell you that isArray is an array.

Remember that in VBA, an array could either be a static array (where the size is defined at compile time) or a dynamic array (where the size can be set or changed during runtime). The IsArray function works for both of these types of arrays. Moreover, the function checks only if the variable is of array data type; it does not verify whether the array has been initialized or not.

Unlock Your Potential


Basic - Advanced


Access Basic - Advanced

Power BI

Power BI Basic - Advanced

Help us grow the project

Leave a Reply

Your email address will not be published. Required fields are marked *