array functions

[djam]

where would I find all the functions related to an array, i looked in the help, but there must be more then that? I'm looking for a function that checks if an array contains a specific element.

Maybe there isn't such a function and I have to write my own?
"so many events, so little time"

 

[Databaseguy]

Here's the general idea. Tweak it to suit your needs.

Private Sub searcharray()

Dim myarray(3) As Variant
Dim i As Integer
myarray(0) = "Dog"
myarray(1) = "Cat"
myarray(2) = "Mouse"
For i = 0 To UBound(myarray) - 1
    If myarray(i) = "Mouse" Then
        Debug.Print myarray(i) & " " & i
    Else
        End If
Next i
End Sub

Tyrone Lumley
augerinn@gte.net

http://server105.hypermart.net/databaseguy

 

[JohnYingling]

There is no function in VB or VBA to find an element with a specified value. I know it doesn't help now but VB.Net does have it with IndexOf.

http://www.VBResizer.com

Forms/Controls Resizing/Tabbing Control

http://www.VBCompare.com

Compare Code (Text)

http://www.VBSortGen.com

Generate Sort Class in VB or VBScript