Right-click on the worksheet tab and choose "View code."

"Phil (tech)" wrote in message
...
Hi,

Thank you both for the help. Gord, that was exactly what I was looking
for!
Can you help me just a little more though please? I'm no VBA expert.
Where
can I find the code that gave the list of values (One, Two, Three) so I
can
customize these to something more relevent?.

Thanks again,

Phil(Tech)

"Gord Dibben" wrote:

Phil

See Debra Dalgleish's site for a sample workbook that does just this.

Allows multiple selections to be placed in one cell.

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, 28 Feb 2007 06:13:30 -0800, Phil(tech)
wrote:

I was given a strange query from one of my users today in Excel, and I
must
admit I found myself clueless as to how to help her. Basically she
wants to
create a drop down list (easy to do), when she makes a selection on
that list
she wants it to appear in a different cell (not so easy), on top of
that,
once she has made that selection, she then wants to click on the same
list
again and make a different selection and have that appear on the same
cell as
the before, but with a comma seperating the two selections. Is there
any way
to do this?