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

  • Thread starter Thread starter Ross Noble
  • Start date Start date
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.
 
I assume you mean data>validation? You cannot select more than one item.

--


Regards,


Peo Sjoblom
 
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

data validation fonts differ in drop down box 1
Formatted cell column in drop down list 1
Multiple selection drop down list 2
Drop Down List - Select Multiple Items 12
customize drop-down box 1
Drop Down with dynamic named range offsheet source list 14
Select Multiples from a drop down list 2
Excel Excel: How do I put a formula in a drop down list 11

Back
Top