in array function

[esthera]

can someone help me with how I would create a function that would take in an array and a value and check if that value exists in the array?

[oracleguy]

Just off the top of my head:

Function inArray(byref array, byval data)
Dim found, arraylen, x
found = false
arraylen = ubound(array)

for x = 0 to arraylen
If array(x) = data Then
found = true
Exit For
End If
Next

inArray = found
End Function

I haven't tested it but that the gist of what you'd have to do.

[ess]

sorry...thought it was a PHP question.

[degsy]

Here is another example
http://forums.aspfree.com/code-bank-54/in-array-function-125932.html