Enter data from a list box or combo box into a range of cells

When I create a list using data validation, I can have a range of cells in a column where I enter items from the list. But when I create a list using a combo box or list box it appears that I can only have one cell where data from the list can be entered. Is there a way to allow the list in a list box or combo box to be entered into multiple cells?

I have a long list of names of contributors, but want to create a periodic report which includes only the contributors on the list who made contributions in the last period. The data validation list works, but is clunky in that for each cell of data to be entered I have to manually scroll down the list (could be a couple of hundred names) to pick the right person. With a list box or combo box I could just start typing the last name and go to the person--this would save much data entry time. Also, it would be nice to change the font size for easier use, although that is not critical.

Thank you.

Thanks. I have no problem populating the dropdown list in either a list box or text box with a range of items to be selected. What I want to do is to use that list to allow the user to pick from the list and put the results into several rows Excel combo box question.JPG. Right now the only way I get is that an item from the dropdown list can be inserted into a single cell, which is fine, but I need to be able to add another item from the dropdown list into another cell. In the Properties for the combo box there is an entry for "LinkedCell" which allows me to enter only 1 cell where the dropdown select will be entered. Is there some way to add a range of cells where items from the dropdown list can be entered? If so, what is the syntax for the "LinkedCell" entry? In the attached picture I want to be able to add 3 items from the dropdown list, one in cell D2 which is now garlic, one in cell D3 from the same dropdown list, e.g., salt, and one in cell D4, e.g. ginger. The dropdown list is the range called "spices" in column a.