It is not a routine, it is a variable being tested for in the case
statement.It applies to VBA, not to Excel itself.

If you want a case type function in a worksheet, there isn't one. There are
many lookup functions that might do what you want, but you would need to
present the problem to tell.

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Al" wrote in message
...
Bob,
Pardon my ignorance but how do I call the myVal routine from within Excel?

"Bob Phillips" wrote:

In VBA, yes


Select Case myVal
Case 1: 'do something
Case 2: 'do something else
Case Else; ' exception
End Select

--

HTH

RP
(remove nothere from the email address if mailing direct)


"Al" wrote in message
...
Does Excel have a function similar to the "Case" command in other
programming
languages?