Thread: Select Case
View Single Post
  #19   Report Post  
Posted to microsoft.public.excel.programming
Bill Renaud Bill Renaud is offline
external usenet poster
 
Posts: 417
Default Select Case

<<In a Select Case statement, the clause "Case Is" is not using the "Is"
operator. Think of "Case Is" as an single operation that just happens to
use the text "Is".

Thanks for the clarification, Chip. "Is" is used as a keyword in the Select
Case statement, as documented in the Select Case Statement in Visual Basic
Help.

From Visual Basic Help:

"Use the Is keyword with comparison operators (except Is and Like) to
specify a range of values. If not supplied, the Is keyword is automatically
inserted."

"Note The Is comparison operator is not the same as the Is keyword used
in the Select Case statement."

--
Regards,
Bill Renaud