Hi All,
This should be simple, but I can't see it.
I have 4 selections to make from a list of 6 choices in 3 separate groups.
[Structure]
lblTEAMS lblDOUBLES lblSINGLES
cboTeams1 cboDoubles1 cboSingles1
cboTeams2 cboDoubles2 cboSingles2
cboTeams3 cboDoubles3 cboSingles3
cboTeams4 cboDoubles4 cboSingles4
[/STRUCTURE]
When I select from the first combobox (cboTeams1), which is populated from a sheet range ("DATA",1,1 - "DATA",6,1), I want the 2nd Combobox (cboTeams2), to be populated by the SAME range MINUS cboTeams1.value. This should cascade down to the last cbo in that list (cboTeams4)
To illustrate:- each successive cbo has one less item (the previous chosen)
cboTeams1 cboTeams2 cboTeams3 cboTeams4
MEMBER1 MEMBER1 MEMBER1 MEMBER1
MEMBER2 [MEMBER2] MEMBER3 MEMBER3
MEMBER3 MEMBER3 MEMBER5 MEMBER5
[MEMBER4] MEMBER5 [MEMBER6]
MEMBER5 MEMBER6
MEMBER6
Hope this is clear enough for my Goal.
Obviously, the code can be duplicated across the 3 groups, as they have the same ListRowSource and will have different allocations of the resultant choices. So I only need help with the 1st groups combo-mechanics.
Thanks for reading, thanks in advance for helping.
Always appreciated
Bruce 54
This should be simple, but I can't see it.
I have 4 selections to make from a list of 6 choices in 3 separate groups.
[Structure]
lblTEAMS lblDOUBLES lblSINGLES
cboTeams1 cboDoubles1 cboSingles1
cboTeams2 cboDoubles2 cboSingles2
cboTeams3 cboDoubles3 cboSingles3
cboTeams4 cboDoubles4 cboSingles4
[/STRUCTURE]
When I select from the first combobox (cboTeams1), which is populated from a sheet range ("DATA",1,1 - "DATA",6,1), I want the 2nd Combobox (cboTeams2), to be populated by the SAME range MINUS cboTeams1.value. This should cascade down to the last cbo in that list (cboTeams4)
To illustrate:- each successive cbo has one less item (the previous chosen)
cboTeams1 cboTeams2 cboTeams3 cboTeams4
MEMBER1 MEMBER1 MEMBER1 MEMBER1
MEMBER2 [MEMBER2] MEMBER3 MEMBER3
MEMBER3 MEMBER3 MEMBER5 MEMBER5
[MEMBER4] MEMBER5 [MEMBER6]
MEMBER5 MEMBER6
MEMBER6
Hope this is clear enough for my Goal.
Obviously, the code can be duplicated across the 3 groups, as they have the same ListRowSource and will have different allocations of the resultant choices. So I only need help with the 1st groups combo-mechanics.
Thanks for reading, thanks in advance for helping.
Always appreciated
Bruce 54
Last edited: