Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I posted this late Friday with no good responses.
I'm trying to figure out which item in a multi select list box was last selected. Not the last item in the list, but the last item selected. For example... A list box with three items "List 1", "List 2", and "List 3". The user could select "List 3" and then "List 1". I would like the algorithm to tell me that on the second Listbox change event... that "List 1" was selected. Then on the flip side.... the logic would have to know whether an item was deselected as well. I played around with using a couple of collection objects... but couldn't come up with a good way to compare the two collections to find the difference... which would in theory tell me what object had changed in the listbox. Any thoughts? Thanks, Brian |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Select a list in 1 cell by selecting an item from another list in | Excel Discussion (Misc queries) | |||
List and subtotal selected items, then print separate item list | Excel Worksheet Functions | |||
Conditional formatting - multi-item text list | Excel Worksheet Functions | |||
Extract values from a multi-select multi-column list-box | Excel Programming | |||
Multi Select List Box | Excel Programming |