If var = 1 Or var = 2 Or var = 3 ....

[Stevenn]

How can I check if a variable is one of some values without using OR many times.

I think it maybe could be possible to write

If variable In ("A", "B", "C") Then
End If

or something like that?

 

[VoG]

Try like this

If IsNumeric(Application.Match(variable, Array("A", "B", "C"), 0)) Then

 

[JackDanIce]

n/a

 

[Firefly2012]

Hi

You could use a Case statement:

Select Case variable
   Case "A","B","C"
      MsgBox "One of my values!"
   Case "D","G","Z"
     MsgBox "One of my other values!"
   Case Else
     MsgBox "Not one of my values"
End Select

 

[Stevenn]

Now my problem is that the line should look something like

If var1 = 8000 And var2 In ("A", "B", "C") Then
End If

 

[VoG]

Try

If var1 = 1000 And IsNumeric(Application.Match(var2, Array("A", "B", "C"), 0)) Then

 

[hurgadion]

Hi,
try using the code:

If var1 = 8000 And Abs(Asc(var2)-66)<=1 Then ...

Best regards

 

[Stevenn]

Thank you! I will use the Match()-function