Singular element of Listbox.Itemsselected collection

[hbrems]

I see a lot of people looping through a Listbox.ItemsSelected collection using a Variant. For example:

dim varItem as Variant

for each varItem in ListBox.ItemsSelect
     ' Do something here
next

I'm wondering which objects are actually held in this collection (equivalent of ListItem in C#). Thanks!

 

[the_net_2.0]

there are no objects in it. the inputs are variants, and those variants serve as references to the indexes of the data type values that you see in listboxes.

i would guess that each collection refers individually to each listbox in an app, because it actually appears to be a property, but not sure 100%

 

[hbrems]

Yep, you're right. Just found this on MSDN:

The ItemsSelected collection is unlike other collections in that it is a collection of Variants rather than of objects. Each Variant is an integer index referring to a selected row in a list box or combo box.

Hmm, too bad...

 

[vbaInet]

You can get the listbox's item in the loop using Listbox.ItemData(varItem) if that's what you're asking.

 

[the_net_2.0]

Yep, you're right. Just found this on MSDN:

The ItemsSelected collection is unlike other collections in that it is a collection of Variants rather than of objects. Each Variant is an integer index referring to a selected row in a list box or combo box.

Hmm, too bad...

msdn is not likely to ever be helpful, because the help files there are verbatim from the help menus in the office programs. It's a complete duplication unless you're looking at a thread in a forum. how do you think i found the information I got?