ExcelBanter - drop-down list

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - drop-down list (https://www.excelbanter.com/excel-worksheet-functions/201310-drop-down-list.html)

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?

On 4 sep, 09:38, roadking wrote:
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?

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

On Thu, 4 Sep 2008 07:38:01 -0700, roadking
wrote:

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?