ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Select Multiples from a drop down list (https://www.excelbanter.com/excel-worksheet-functions/224963-select-multiples-drop-down-list.html)

Shiela

Select Multiples from a drop down list
 
Is it possible to select multiple items from a drop down list?

Dave Peterson

Select Multiples from a drop down list
 
You could use a listbox instead.

Shiela wrote:

Is it possible to select multiple items from a drop down list?


--

Dave Peterson

Gord Dibben

Select Multiples from a drop down list
 
Using Data Validation dropdown list.................yes.

Download a sample workbook from Debra Dalgleish's site.

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

Note that you can have the selections in an adjacent cell or in the same
cell.

As written it creates a comma delimited list of selected entries.


Gord Dibben MS Excel MVP

On Thu, 19 Mar 2009 19:34:17 -0700, Shiela
wrote:

Is it possible to select multiple items from a drop down list?




All times are GMT +1. The time now is 08:32 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com