Loop through listbox selecting second column values? 1

[glgcag]

I have a listbox that is multiselect. As I'm grabbing the keys in the first column, I want to grab the descriptions in the second column to cram into a string for display purposes.

Here's the code to grab the first column:

    For Each varItem In Me.lstOtherCriteria.ItemsSelected
        sID = sID & Me.lstOtherCriteria.ItemData(varItem) & ";"
    Next varItem

Since this code only grabs the first column data, is it possible to use a reference to the second column to get at it's information, to the effect of:

me.lstOtherCriteria.ItemData(varItem).Column(1)

I know this code won't work, because it won't recognize the "Column(1)" after the itemdata property and it errors out. Not sure how to make it work, even if it's possible . . .

Any help is appreciated!

 

[PHV]

Have you tried this ?
sID = sID & Me.lstOtherCriteria.Column(1, varItem) & ";"

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[glgcag]

AWESOME! It's these little things that drive me nuts and you nailed it right out of the box! THANK YOU!

glgcag