Multi-Select listbox selection order

[TonyT]

Hi,

I'm using a multiSelect listbox, but need to know the order that the items
were selected. Is there a way to do this without *lots* of coding after each
item has been selected (I know I'll need some coding to de-select the whole
list if the primary selection is de-selected) ie. can the ItemsSelected
property be ordered in such a way?

 

[Stuart McCall]

Hi,

I'm using a multiSelect listbox, but need to know the order that the items
were selected. Is there a way to do this without *lots* of coding after
each
item has been selected (I know I'll need some coding to de-select the
whole
list if the primary selection is de-selected) ie. can the ItemsSelected
property be ordered in such a way?

No the ItemsSelected collection is read-only. You can, however, maintain
your own collection, by adding to it in the OnClick event:

With Me.ListboxName
If .Selected(.ListIndex) Then
MyCollection.Add .ListIndex
End If
End With

Then you can read them out of MyCollection, in clicked on order. To clear
MyCollection, just do:

Set MyCollection = New Collection

 

[TonyT]

Thanks Stuart,

Now why didn't I think of that? As usual overlooking the obvious in search
of complication....<g>

TonyT..