VBA - IsArray Function



The IsArray Function returns a boolean value that indicates whether or NOT the specified input variable is an array variable.

Syntax

IsArray(variablename)

Example

Add a button and add the following function.

Private Sub Constant_demo_Click()
   Dim a,b as Variant
   a = array("Red","Blue","Yellow")
   b = "12345"
  
   msgbox("The IsArray result 1 : " & IsArray(a))
   msgbox("The IsArray result 2 : " & IsArray(b))
End Sub

When you execute the above function, it produces the following output.

The IsArray result 1 : True
The IsArray result 2 : False
vba_arrays.htm
Advertisements