How do you select multiple characters in a drop down list to appe.
 

How do you select multiple characters in a drop down list to appear in one
cell? Mainly, displaying multiple values or words after selecting more than
one choice from the drop down box so they can be displayed in the one cell
that the drop down box is located in.

How do you select multiple characters in a drop down list to appe.
 

I assume you mean datavalidation? You cannot select more than one item.

--


Regards,


Peo Sjoblom

"Ross Noble" <Ross wrote in message
...
How do you select multiple characters in a drop down list to appear in one
cell? Mainly, displaying multiple values or words after selecting more
than
one choice from the drop down box so they can be displayed in the one cell
that the drop down box is located in.

How do you select multiple characters in a drop down list to appe.
 

Debra Dalgleish has a sample workbook with code that can do this.

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 Mon, 11 Aug 2008 12:34:03 -0700, Ross Noble <Ross
wrote:

How do you select multiple characters in a drop down list to appear in one
cell? Mainly, displaying multiple values or words after selecting more than
one choice from the drop down box so they can be displayed in the one cell
that the drop down box is located in.