Select Case of with more variables

Hello everybody,
I have three dropdown menus (lets say: Drop1, Drop2, Drop3) with three options each (lets say: A, B, C) and I would like to consider all the possible combinations once a user submit a form where those dropmenu are included.
If I pass those value as :
Dim CM, Carrier, Destinatio
CM=request.form(Drop1)
Carrier=request.form(Drop2)
Destinatio=request.form(Drop3)
CM could A or B (same as  Carrier and Destination)
Now instead of having nested If..then ElseIF ....confusing condition:
IF CM=A and Carrier=A THEN
    IF Dest=A THEN
    (........)
   ELSEIF DEST=B
    (.....)
   End IF
ELSEIF CM=A and Carrier=B
 .............
Is there a way to consider all the combinations but using another method such as "select case of" so that it wuold look more clear to read.
Thank you.
 
ggmisadminAsked:
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

rettiseertCommented:
mmm... how about...

Dim CM, Carrier, Destinatio
Dim AllThreeResults

CM=request.form(Drop1)
Carrier=request.form(Drop2)
Destinatio=request.form(Drop3)

AllThreeResults = CM & "|" & Carrier & "|" & Destinatio

select case AllThreeResults
   Case "A|A|A":
   Case "A|A|B":
   Case "A|A|C":
   Case "A|B|A":
 ....
end select
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
RobSampsonCommented:
Do you *really* to do something unique based on each individual combination?  What is the action that you might take based on a combination?  The reason I ask is because if rather than nest it, you just go through each select box one after the other, you might still be able to do the same thing....

Regards,

Rob.
0
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
ASP

From novice to tech pro — start learning today.