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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

customize drop-down box 1
Drop Down List - Select Multiple Items 12
drop down list 3
Excel Excel: How do I put a formula in a drop down list 11
Select Multiples from a drop down list 2
Formatted cell column in drop down list 1
How do I create a drop down box within a drop down box? 1
Multiple selection drop down list 2

Top