Se7enSquared
10/18/2019 - 11:31 PM

Is item in array?

Return True if value is in an array of values

' ----------------------------------------------------------------
'Function: IsInArray
'Purpose: return True if a value is in an array of values
'Params: Variant: value to find in array
'        Array of Variant: array to search
'Return: Boolean: True if is in array, false otherwise
' ----------------------------------------------------------------

Private Function IsInArray(valToBeFound As Variant, arr As Variant) As Boolean
    Dim element As Variant
    On Error GoTo IsInArrayError: 'array is empty
        For Each element In arr
            If element = valToBeFound Then
                IsInArray = True
                Exit Function
            End If
        Next element
    Exit Function
    
IsInArrayError:
    On Error GoTo 0
    IsInArray = False
End Function