Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
remove convert/extract the number from'12345.56; ie remove ' sign | Excel Worksheet Functions | |||
How do I remove hyperlink if 'remove' option is disabled | New Users to Excel | |||
Making pick list conditional on selection from previous pick list | Excel Discussion (Misc queries) | |||
Is there a way to pick the cells to add using sum? | Excel Worksheet Functions | |||
Is there a way to remove numbers w/o remove formulas | Excel Programming |