| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
select case multiple conditions
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
|
|||
|
|||
|
select case multiple conditions
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 | |
|
|
Similar Threads
|
||||
| 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 | |||
Hybrid Mode
