Select Case syntax

[confusion123]

I recall reading somewhere that there is a difference between:

Select Case MyVal

    Case "Apple"

and

Select Case MyVal

    Case Is = "Apple"

Is that true?

If so, what is the distinction?

 

[Jerry Sullivan]

Here's how the VBA Language Reference describes the use of Is in Case Statements

https://msdn.microsoft.com/en-us/library/office/gg278665.aspx

The Is expression allows the use of other comparison operators...

 Select Case MyVal
    Case Is > "AAA"

...however I can't think of a scenario where there would be a difference in the result from using Is with an "=" operator versus using just the expression by itself.

Case Is = "Apple"

Case "Apple"

 

[confusion123]

Here's how the VBA Language Reference describes the use of Is in Case Statements

https://msdn.microsoft.com/en-us/library/office/gg278665.aspx

The Is expression allows the use of other comparison operators...

 Select Case MyVal
    Case Is > "AAA"

...however I can't think of a scenario where there would be a difference in the result from using Is with an "=" operator versus using just the expression by itself.

Case Is = "Apple"

Case "Apple"

Thanks

I thought there IS a difference if you're checking for True / False.

 

[Jerry Sullivan]

Thanks

I thought there IS a difference if you're checking for True / False.

I don't think so. These two statements will generate the same result:

Case Is = True

Case True