Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Is there any easier way ?
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.... |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there an easier way? | Excel Worksheet Functions | |||
Easier said than done | Excel Programming | |||
There's Got to be an Easier Way | Excel Discussion (Misc queries) | |||
Is there an easier way? | Excel Discussion (Misc queries) | |||
Easier Way? | Excel Worksheet Functions |