You'd have to use a Worksheet_Change event in VBA, if that's something you
want to delve into


"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?