Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On Jun 18, 7:54 am, Chris G wrote:
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 select case true case var_a=x and var_b10 case var_a=y and var_b10 case var_a=x and var_b<11 etc end case Tom Lavedas =========== http://members.cox.net/tglbatch/wsh/ |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I like it - very clever Tom. Thanks
"T Lavedas" wrote: On Jun 18, 7:54 am, Chris G wrote: 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 select case true case var_a=x and var_b10 case var_a=y and var_b10 case var_a=x and var_b<11 etc end case Tom Lavedas =========== http://members.cox.net/tglbatch/wsh/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Case without Select Case error problem | Excel Discussion (Misc queries) | |||
select multiple records in database given conditions | Excel Worksheet Functions | |||
Changing multiple cell text from lower case to upper case | Excel Discussion (Misc queries) | |||
End Select without Select Case, Block If without End If errors | Excel Programming |