Select multiple values from list/combo box - writing to seperate r

D

dfeigen115

I am looking for assistance to do the following combination of actions:

1) I'd like to be able to select multiple entries from a combo or list box
using the CLICK + CTRL/SHIFT key combos (there are also to static fields on
the form)

2) each individiual selections and the 2 static fields need to be written to
a distinct row in a table.

Any assistance would be appreciated.
Thanks,
Dan
 
K

Klatuu

Forget the combo for this exercise. They are limited to one selection.
You will want a list box with the Multi Select property set to Extended.
To determine what is selected in a MultiSelect list box, see VBA Help for
the ItemsSelected property. It even has a good example of how to loop
through the collection. Then just loop through the collection and add a new
row to your table for each selected item.
 
Top