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

R

Ross Noble

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.
 
P

Peo Sjoblom

I assume you mean data>validation? You cannot select more than one item.

--


Regards,


Peo Sjoblom
 
G

Gord Dibben

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
 
Top