I would maintain two listboxes (actually I use the listview controls in
report view - they are sexier)
The buttons would perform the moving between. Or if you want to get really
smart you could play with the dragdrop facilities.



"Leo Elbertse" wrote in message
...
I've been searching quite a number of excel sites but haven't found
what I'm looking for:

The standard dialogbox (similar to the box you get when you click on
the 'To' button in Outlook|New Message). The box has 2 picking lists:

- left - not chosen yet
- right - chosen items

Clicking on an item in either list will transfer the item to the other
list.

In addition there are the 'Add All' and 'Remove All' buttons, that
respectively add all items from the left list to the right, and remove
all all items from the right list to reinstate them in the left.

I suppose there are numerous ways to manage this and am looking at:

- An adaptation of J Walkenbach's GetOption
- The, for me brandnew, Dictionary-object

Should anyone have a pertinent idea how to tackle this issue, or for
that matter know of a existing template, I'm all ear.

On the other hand, should this really be something new and should you
want to have a copy of the final VBA, just drop me a line.

Leo