View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Chris G Chris G is offline
external usenet poster
 
Posts: 5
Default select case multiple conditions

Is is possible to use a select case arrangement with more than one
conditional variable because if I nest it using another select case or an if
statement the code gets much longer and is not so easy to follow.

eg I tried something like this but couldn't get it to work
select case var_a, var_b
case var_a=x, var_b10
case var_a=y, var_b10
case var_a=x, var_b<11
etc
end case

Any alternative suggestions welcome

Thanks