Look at that page again, at that topic (Data Validation) and it's down in the
list if you scroll down about 1/3 of the way. You could do [ctrl]+F and
search for
Select Multiple Items from Dropdown List
on that page and it'll take you right to it. The link to the sample file is
this:
http://www.contextures.com/DataValMultiSelect.zip

"Andyroo" wrote:

> Hi,
>
> I can`t find "Select Multiple Items from drop down List", any other
> suggestions ? I appreciate it
>
> "Debra Dalgleish" wrote:
>
> > As answered in microsoft.public.excel.worksheet.functions:
> >
> >
> > You can do this with data validation and programming. There's a sample
> > file here:
> >
> > http://www.contextures.com/excelfiles.html
> >
> > Under Data Validation, look for 'Select Multiple Items from Dropdown List'
> >
> > Andyroo wrote:
> > > Hello,
> > >
> > > I need to analyse survey data in excel. I can make a drop down list in
> > > Excel, via Validation, and get the option to enter one choice. However, one
> > > question asks respondents to select "all" that apply.
> > >
> > > I do not know how to do this, there are anything from one to six selections.
> > > The ideal choice would be to be able to selct more than one rather than have
> > > to enter each choice as a new column.
> > >
> > > Any help would be much appreciated
> > >
> > > Thanks
> >
> >
> > --
> > Debra Dalgleish
> > Contextures
> > http://www.contextures.com/tiptech.html
> >
> >