Return row index of selected items in multicolumn multiselect listbox

[CaptainK]

I have a listbox with 8 columns. Multiselect is enabled, and it must stay this way. As part of my program, after the user presses a command button, I need to use the row indexes of the selected rows in order to copy the selected information into an array which is then placed in a different listbox, and then delete the items from the original list. Pseudocode of what I want to do:

Please Login or Register  to view this content.

But my understanding is that .ListIndex does not work this way with multiselect listboxes. I've tried searching for a solution for a while, but I cannot find one. Is there any way to accomplish what I want to here?

[ajryan88]

Hi,

I have built a miniature working example of what I think you're asking for.

Let me know if it helps

[ajryan88]

Sorry I didn't read your post properly...I have missed the "multiple columns" part. Let me have another go and get back to you

[ajryan88]

Try this version instead...

[CaptainK]

Holy cow, that works great! Not only is it much much (much) simpler than what I was going for, it runs a little bit faster (by a split second, but the difference is noticable). Thanks so much!

[ajryan88]

You're welcome