Adding multiple selections in a list box to a table

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a list box that lists my inventory items. I have it set up that one
can choose multiple items (extended). What I need to do is add the code that
will add each of the items to a table for later use. I can do it fine if only
one item is selected, but can not remember how to get move on to the next
selection in the list box so all items selected are added to the table.

I have done this before, but have been away from VBA for awhile and can not
remember how.

Thanks
Mary
 
What kind of list box is this, is it on an Outlook form or a VB/VBA form?

For an Outlook form you can use the Selected(index) Boolean property. If the
line is selected the result will be True. For a VB/VBA form you can use
SelCount in addition to Selected.
 
Back
Top