ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Multiple selections (https://www.excelbanter.com/excel-discussion-misc-queries/156394-multiple-selections.html)

Confuddled User!!!!!!!!!!!!!

Multiple selections
 
Can Excel perform multiple selections from a drop down list? I know in HTML
you can hold down a key and select multiple items. Also, if it is the case
that Excel can do this, how would the relative values be stored in a cell?

Thanks

Max

Multiple selections
 
Try Debra's sample file at:
http://www.contextures.com/excelfiles.html
Under Data Validation, look for:
DV0017 - Select Multiple Items from Dropdown List
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"Confuddled User!!!!!!!!!!!!!" wrote:
Can Excel perform multiple selections from a drop down list? I know in HTML
you can hold down a key and select multiple items. Also, if it is the case
that Excel can do this, how would the relative values be stored in a cell?

Thanks


Dave Peterson

Multiple selections
 
Maybe you could use a Listbox that's setup up for multselect?

Confuddled User!!!!!!!!!!!!! wrote:

Can Excel perform multiple selections from a drop down list? I know in HTML
you can hold down a key and select multiple items. Also, if it is the case
that Excel can do this, how would the relative values be stored in a cell?

Thanks


--

Dave Peterson

NeedHelpToo

Multiple selections
 
Did you figure this out? I have the same question.

"Confuddled User!!!!!!!!!!!!!" wrote:

Can Excel perform multiple selections from a drop down list? I know in HTML
you can hold down a key and select multiple items. Also, if it is the case
that Excel can do this, how would the relative values be stored in a cell?

Thanks



All times are GMT +1. The time now is 05:58 PM.

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