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 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 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.