ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   multiple item entries from drop-down list (https://www.excelbanter.com/excel-discussion-misc-queries/90267-multiple-item-entries-drop-down-list.html)

sgoldstand

multiple item entries from drop-down list
 
How set up a drop-down list where multiple items can be selected

Ardus Petus

multiple item entries from drop-down list
 
Insert a ListBox

HTH
--
AP

"sgoldstand" a écrit dans le message
de news: ...
How set up a drop-down list where multiple items can be selected




Miguel Zapico

multiple item entries from drop-down list
 
One way is using Data-Validation, and selecting list in the "Allow" field.
You have to choose the source of the data, that can be a range of cells or
whatever you type on the source textbox. Finally, ensure that "in-cell
dropdown" is checked.

Hope this helps,
Miguel.

"sgoldstand" wrote:

How set up a drop-down list where multiple items can be selected


Debra Dalgleish

multiple item entries from drop-down list
 
You can do this with data validation and programming. There's a sample
file he

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'Select Multiple Items from Dropdown List'


sgoldstand wrote:
How set up a drop-down list where multiple items can be selected



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html



All times are GMT +1. The time now is 01:12 AM.

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