Hi there,

I am looking for a "safe" way to compare a number with an array full of numbers.

Example:


Code:
Sub CheckSomething
    Dim levelArray(5) As String
    Dim toSearch As String
    levelArray(0) = 1
    levelArray(1) = 2
    levelArray(2) = 3
    levelArray(3) = 10
    levelArray(4) = 12
    toSearch = 31                               
    If InStr(Join(levelArray), toSearch) > 0 Then
    MsgBox ("Found " & toSearch)                                
    End If
End Sub
The problem with my example is that we are searching a string, so if toSearch is for examle 31, then it will say "found" because it contains a 1. Same for 21 etc..

What I am looking for is a way to search the exact number in my array and not just showing "found" because the 1 in in the number 31.

Maybe you could be so nice and post a working example to compare exact numbers as this will be very helpful to me. Also, if there is a better was to create an array, feel free to let me know so I can optimize the code. I come from the PHP corner and it'smuch easier to do with php

Thanks!