Multiselect list boxes

  • Thread starter Jonathan Crawford
  • Start date
J

Jonathan Crawford

Hi

I can go through a list box
enumerating the items, however
I need to pick up columns as well

For Each varItem In Lst_Batches.ItemsSelected
Debug.Print Lst_Batches.ItemData(varItem)
Next varItem

This picks up the first column but I was hoping
Debug.Print Lst_Batches.ItemData(varItem).Column(3)
might return values but it comes
up with object required

I am up a creek with this one

thanks

jonathan
 
D

Douglas J. Steele

Lst_Batches.Column(3, varItem) will return the 4th column of each selected
row.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top