I have viewed Debra's DV0017 workbook and the instructions only say to
right-click on the worksheet tab to view the code. It doesn't tell me what
function to place in my worksheet so that I receive multiple items from a
drop-down. Please help me understand what I should do with Debra's DV0017 to
ensure I get multiple items from a drop-down into my worksheet. Thanks!

"Gord Dibben" wrote:

See Debra Dalgleish's site for a workbook download showing how to select
multiple items from a DV list.

DV0017 - Select Multiple Items from Dropdown List-- Select multiple items from a
dropdown list; an event macro stores selections in adjacent cell, or in same
cell. DataValMultiSelect.zip 18kb updated 22-Feb-07

http://www.contextures.on.ca/excelfiles.html#DataVal


Gord Dibben MS Excel MVP

On Wed, 30 Apr 2008 13:48:01 -0700, VLH wrote:

I need to select multiple items from a drop-down list that I created because
there are times where more than one item is needed.

For example, my drop-down list might contain the following:
apples, oranges, pears, lemons, mangos

I want the data cell to show that I selected: apples, oranges, pears (for
example).

Is this possible?