Select Case syntax?

[mossimo]

Is there any real difference between these two ways of writing select case statements?

Select Case(sVariable)
  Case “1” : Do(this) : Do(that)
  Case “2” : Do(thistwo) : Do(thattwo)
End Select

OR THIS:

Select Case(sVariable)
  Case “1”
    Do(this)
    Do(that)
  Case “2”
    Do(thistwo)
    Do(thattwo)
End Select

Cheers
mossimo

 

[tsuji]

Hello mossimo,

They are the same. ":" is just a separator for successive instructions placing on the same line.

Only problem, as I see it, is your use of "“”". They won't do for string delimiter.

Further minor issue is your renderment of select case:
Select Case(sVariable)
It is ambiguous here as it might be mistakenly conceived case as a function of some kind. Encircling a variable is no problem, sometimes necessary. If you use it here, distance it with the case keyword
Select Case sVariable
or
Select Case (sVariable)

regards - tsuji

 

[mossimo]

Yes you are correct it should actually be Select Case sVariable.

Only problem, as I see it, is your use of "“”". They won't do for string delimiter

It looks like copy and pasting wasn’t a good idea because it should be "1" and not “1”

Thanks tsuji

Cheers
mossimo