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?
|