Check existing value in array
Function InSArray(ByRef vArray() As String, ByVal vValue As String) As Boolean
'***Return true, if found this value in array***'
'***Return false, if not found this value in array***'
Dim i As Long
For i = LBound(vArray) To UBound(vArray)
If vArray(i) = vValue Then
InSArray = True
Exit Function
End If
Next i
InSArray = False
End Function
No comments:
Post a Comment