View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default How do I create multi choice selec drop down list in Excel ple

Debra Dalgleish has a sample workbook with DV dropdown list and code to allow
multiple selections fro a list.

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

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


Gord Dibben MS Excel MVP

On Mon, 3 Mar 2008 07:27:01 -0800, JillyB
wrote:

Hi Kevin,

Thanks for your reply. I need to be able to select more than one choice at
a time from the drop down. Can this be done. e.g. Drop down list of areas,
i.e. southampton, reading, basinbgstoke, heathrow and I need to selec t
perhaps heathrow and reading at the same time from the drop down?

"Kevin B" wrote:

In a column to the right of your data, enter the selections you want to use
in the drop down box, one per cell. Move to the cell where you want to start
the drop down list and click DATA in the menu and select VALILDATION. Click
the combobox drop down to display a list of allowed types and select LIST.
Then in the SOURCE field, click the EXPAND dialog box on the right side of
the text box, selet the range that has your list and click the COLLAPSE
dialog box on the right side of the text box to return to the DATA VALIDATION
dialog box. Click OK to complete and then copy the cell with the assigned
data validation settings and paste in all the cells you want to use the list
in.

Hope this helps...
--
Kevin Backmann


"JillyB" wrote:

I urgently need to create a drop down list in excel with multiple choice
selections - is this possible please? How do I do it .

Thanks