Hi,
I'm new to VBA so please bear with me. Basically I have 8 combobox's with the same datalist. What I would like to do is remove each item selected from the available items in the next combobox datalist (so that an item can only be selected once). So if the datalist was:
Asbestos
ATW
BRK
CAR
PLM
and the Combo1.Value = Asbestos then the datalist for Combo2 would be:
ATW
BRK
CAR
PLM
and Combo2.value = BRK then the datalist for Combo3 would be:
ATW
CAR
PLM
and so on....
There are 64 items in the list.
Can anyone help?
Bookmarks