My scenario:

cmb = Combobox
xxx= Combobox selected value
cmb23.list - cmb32.list are Conditional upon the cmb to the LEFT (cmb32{B} with cmb2{A}...) selected value.

A B
cmb2 cmb23
xxx xxx

cmb3 cmb24
xxx xxx

cmb4 cmb25
xxx xxx
etc.....
cmb11 cmb32
xxx xxx


What i am trying to achieve is to ELIMINATE the chance of the user Selecting the Same {A}cmb AND the same {B} cmb.values as the user progresses from the Top DOWN.

The top 2 were not too bad to code such as:

In instance for cmb24:
If cmb24.value = cmb23.value And cmb3.value = cmb2.value then msgbox "That selection has been chosen already !!"

But as you go down the list, the possible combinations dramatically increases.

Can you image the logical code size when i get to the 10th cmb's?

Is there any easier way to do this?


I cannot simply rely on the {B} cmb.value alone, as they CAN have the SAME value in their list but the actual data is NOT the same literal cell.value.

Any idea's

Corey....