drop-down list

  • Thread starter Thread starter roadking
  • Start date Start date
R

roadking

I am making a spreedsheet dealing with resumes, I made a drop down list, is
there a way that I can select more then one topic from the drop down list?
 
I am making a spreedsheet dealing with resumes, I made a drop down list, is
there a way that I can select more then one topic from the drop down list?
Click to expand...

Hi roadking:

First of all, I apologize for my English.

What you need is a ListBox.

In the ListBox, set the Multiselect property to fmMultiSelectMulti or
fmMultiSelectExtended, depending on your needs.
 
If a Data Validation dropdown see Debra Dalgleish's site for a sample
workbook that allows this.

http://www.contextures.on.ca/excelfiles.html#DataVal

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


Gord Dibben MS Excel MVP
 

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

Dependent drop down dynamic range formula, off sheet. 7
Formatted cell column in drop down list 1
Drop Down with dynamic named range offsheet source list 14
Excel Excel: How do I put a formula in a drop down list 11
Copy corresponding cell in Column B if cell in A contains certain text? 1
Data Validation - Conditional List 3
How do I setup a drop down box for using addresses 4
customize drop-down box 1

Back
Top