Remove Items from Combobox if selected in Another Combobox

I Am looking for a way to remove an item from the other comboboxes if selected in another. The basic setup is that when the userform loads it adds the same items to all 4 comboboxes.... What I need to do is have it remove from the other 3 comboboxes if selected in any of the 4 comboboxes.... then if the selection changes re-add the previously selected item back to the other comboboxes. I uploaded a sample sheet with my failed attempt at it.

Something like this:

Please Login or Register  to view this content.

You could probably do this in one routine but is a little more complicated code, this is simple and straight forward

Keebellah,

I need it to populate all the comboboxes on opening of the form and the Items that are added to it are file names that are stored on a share drive... I just used the ABC's as a filler for the sample file

Okay, clear.
I would suggest then that you first read the list of files into an array and apply the same method.
Dose this mean that the list may vary ?

List will not vary. Not quite sure how to use an array that's why I tend to shy away from using them

can the user select any combobox or does the user start with the topmost and then the next ?

They can start with any combobox.
Found this UDF to create the Array.... Over on http://forums.devshed.com/visual-bas...ue-342763.html

Not sure if its a step in the right direction or not

Please Login or Register  to view this content.

This can be used, but the fact that the user may select any combobox at will makes the coding it a little more complicated

Just curious, is there any special reason why you have named the comboboxes as you did? Why start with m3 and not m1?
If I understood you correctly the user may start with any box.
My idea would be start with the first and then allow the second one etc etc.

direct relation to the label on the userform... just didn't include the labels

Okay, understood, I'll see if I can put together a basic working routine for you.
The rest you can always edit and tweak

Thank you for you help so far on this

Try example file. After changing all 4 Combo's you have to push Reset button to start over again.

I did not include the rest button but this is my idea, I have not looked at @bakerman2 's solution

P.S. You will have to chang the filepath used

Keebellah'

your way works, but if the user select an item for all them then decides to change there mind the available options do not update...

bakerman2,

your way does remove the item, but I need it to add it back if the user decides to change their mind hopefully with out the use of a rest button.

The Item do not have to be in the same order if that's not a possibility

I modified it adding @bakerman2's button and reset button.
Don't forget the filepath

So here's what I have come up with (a lot of it is form google searches) that works to add/remove items from all the comboboxes on the userform.... Its not as I had hoped in that it does not place them back in the same order but I'm not sure if that is possible or how much work that is going to be...

Please take a look at it and let me know if there is anyway that it can be made better.

I will leave this thread opened for a few more days then mark solved there is no more movement on it....

Once again thank you both for your input