View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Helmut Weber[_2_] Helmut Weber[_2_] is offline
external usenet poster
 
Posts: 163
Default Can I use "or" in a select case construct?

Hi,

you don't use "is" here.

I cant't explain all that there is to "is",
and I doubt if I would be able to.

Use a comma for "or", like:

Dim s As String
s = "<"
Select Case s
Case "<=", "<": MsgBox "< or <="
End Select

--
Greetings from Bavaria, Germany

Helmut Weber, MVP WordVBA

Win XP, Office 2003
"red.sys" & Chr$(64) & "t-online.de"