Removing specific entries from comboboxes
 

Dear All,

i have a userform with four comboboxes from which the user makes their
choice (then for each combobox, some extra info is completed in adjacent
textboxes. all comboboxes could potentially start with the same list of
data, but what i want to do is remove the list item from an unused combobox
if it has already been selected in another combobox previously (but then if
that first one changes, the item then becomes available again in the
remaining comboboxes). ie, if the complete list contains five items and one
is chosen in one of the comboboxes, the remaining 'boxes have only four (and
so on until all the boxes have selections made). so the question is, how
can i make it 'look up' the already selected items and remove it from the
remaining combobox lists?

i hope that is clear and i hope someone can help me.

Many thanks,

tim