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.... |
All times are GMT +1. The time now is 03:34 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com