I have a form with multiple comboboxes where names can be selected,
all driven from a common array filled from a range on a hidden data
sheet. What I'm trying to achieve, and probably just missing
something really simple, is management of what happens when a name
needs removed or re-added to the combobox list.

I know I can handle the removal of one of the items in the list in
various ways, e.g. by removing it from the array that drives all the
comboboxes.

The problem I'm having is coming up with an elegant way for an item to
reappear on the list of 'free' names if a once-populated combobox is
then cleared. I can't help feeling there is just some method I've
never had to use that should so this, such as having the comboboxes
linked, but Office Help and the internet are not bringing up anything
really relevant.

I was reduced to trying to juggle multiple arrays/ranges with events
adding and removing items from each - seemed very nasty, and that
usually means I'm trying to do something the hard way!

Can this be done without hundreds of lines of code and lots of ugly
updates to a data sheet? Or am I barking up the wrong tree and is
there another, better way of achieving much the same result?

--
Gordon