CHECK if value is in ????

[sal21]

Instead to use multiple if...end to intercept a value for condition is possible to check if value is present in a strng array???

example:

if AA
is this array (AA,AB, AC,......ZZ)
then

i hope you understabd me:-)

[HansV]

You could use

Code: Select all

Dim MyVar As String
MyVar = ...
Select Case MyVar
    Case "AA", "AB", "AC", "ZZ"
        ' Do something
    Case Else
        ' Do something else
End Select

[sal21]

You could use

Code: Select all

Dim MyVar As String
MyVar = ...
Select Case MyVar
    Case "AA", "AB", "AC", "ZZ"
        ' Do something
    Case Else
        ' Do something else
End Select