Thread: is there a "switch p, case 1 2 3 ...." flow control in Excel?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default is there a "switch p, case 1 2 3 ...." flow control in Excel?
Check out Select Case statements in VBA help.


Gord Dibben MS Excel MVP


On Mon, 17 Dec 2007 12:28:02 -0800, sweder
wrote:

I want to execute one out of 5 formulas depending on whether a switch
variable takes the value 1, 2, 3, 4 or 5. Most programming languages have a
"switch p, case 1 F1, 2 F2, etcetera construct. Does that also exist in
Excel? I am using office 2003.

Reply With QuoteReply With Quote