nikischwabe
Programmer
I've got a feeling this one should be simple but it is causing me a hedache at the moment, and I can't find a relevant FAQ.
I have listbox (multi select) with 'Value List' as a the RowSourceType.
I thought something simple like this might work:
For Each i in listbox.ItemsSelected
listbox.RemoveItem (i)
Next
Of course it isn't that simple because the index changes as soon as the first row is deleted.
Can anyone tell me if there is an easier way to delete multiple selected items in the list?
Or am I having one of those 'thicker than air' days?
Nice one
I have listbox (multi select) with 'Value List' as a the RowSourceType.
I thought something simple like this might work:
For Each i in listbox.ItemsSelected
listbox.RemoveItem (i)
Next
Of course it isn't that simple because the index changes as soon as the first row is deleted.
Can anyone tell me if there is an easier way to delete multiple selected items in the list?
Or am I having one of those 'thicker than air' days?
Nice one