Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
sgoldstand
 
Posts: n/a
Default multiple item entries from drop-down list

How set up a drop-down list where multiple items can be selected
  #2   Report Post  
Posted to microsoft.public.excel.misc
Ardus Petus
 
Posts: n/a
Default 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



  #3   Report Post  
Posted to microsoft.public.excel.misc
Miguel Zapico
 
Posts: n/a
Default 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

  #4   Report Post  
Posted to microsoft.public.excel.misc
Debra Dalgleish
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Dynamic Drop Down List I''m Still Here Excel Discussion (Misc queries) 5 March 22nd 06 08:46 PM
Advanced Excel Drop down List chriscana Excel Discussion (Misc queries) 4 March 21st 06 01:35 PM
Extract each item in the list 0-0 Wai Wai ^-^ Excel Worksheet Functions 1 December 11th 05 06:26 PM
changing value of a cell by selecting an item from a drop down list Bobby Mir Excel Worksheet Functions 6 June 8th 05 08:33 PM
Drop down list with multiple choices Cindy Excel Worksheet Functions 6 March 30th 05 01:35 AM


All times are GMT +1. The time now is 12:09 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"