OR statement limitations

[UnsolvedCoding]

Does anyone know the max number of OR operators that can be in the same line of code?

I haven't found anything to state if there are or are not limits.

 

[SkipVought]

There is another way: Select Case Statement

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[Andrzejek]

They don't have to "be in the same line of code":

If A = 2 Or B = 5 Or C = 10 _
   Or X = 13 Or Y = 66 Then
      ...
End If

I don't think there is a limit (unless someone proves me wrong...)

Have fun.

---- Andy

A bus station is where a bus stops. A train station is where a train stops. On my desk, I have a work station.

 

[SkipVought]

That If statement is one LOC.

If you have if x is 1 or 3 or 17 Then...

Select Case x
Case 1, 3, 17
'True result expressed here
End Select

Skip,
[sub]
Just traded in my OLD subtlety...
for a NUance![/sub]

 

[UnsolvedCoding]

I am using or because of others involved. Select case would be a better choice and it looks like that will be where the code ends up.

Right now there are around 8 OR's being evaluated at the same time. To put it politely - ick.

 

[DaveInIowa]

If it makes sense for your situation, consider assigning a logical "group" of conditions to a single variable. It could help with comprehending the overall condition.

Dim thisIsTrue As Boolean
Dim thatIsTrue As Boolean

thisIsTrue = (A = 2 Or B = 5 Or C = 10)
thatIsTrue = (X = 13 Or Y = 66)

If (thisIsTrue Or thatIsTrue) Then

End If

 

[UnsolvedCoding]

I went with a select statement because I was tired of repeating myself with OR.

Thanks to all for the help.