List of options

[Rob.Mills]

I need to setup a procedure that will analyze several factors and depending on the combination will execute certain commands. The number of different options will be up to 24. I know how to do it by nesting if then... else statements, which will require a lot of them.

Just wondering if anyone knows of a different way of doing this. I thought about using a select statement but the way this is configured I think that will require just as much coding.

Any ideas??

 

[Jack Cowley]

If you have 24 definite options then you will have to code for 24 possibilities. I would suggest Select Case as it does not have to process every statement as an If - Then does....

hth,
Jack

 

[raskew]

Depending on the scenario, the Switch()function can often provide a shorter coded solution than Case Select.

It would be helpful if you'd post an example.