SEARCH IN ARRAY

[sal21]

DIM MYSTRING As String, MYARRAY() As String
...

MYSTRING = "1-NORD-OVEST|2-NORD-EST|4-SUD|3-CENTRO|5-ISOLE"
MYARRAY = Split(MYSTRING, "|")
...

Ho to check if

VALORE="3-CENTRO"

if VALORE exists in array or in MYSTRING?

[HansV]

Code: Select all

    If Instr("|" & MYSTRING & "|", "|"&VALORE & "|") Then
        ' Found
    Else
        ' Not found
    End If

[p45cal]

in array:

Code: Select all

If IsError(Application.Match(VALORE, MYARRAY, 0)) Then
  'not found
Else
  'found
End If

[HansV]

Sal21 works in VB6, not in Excel...

[snb]

Code: Select all

msgbox ubound(filter(myarray,"3-CENTRO"))>-1