I am trying to set up dropdown lists in MS Excel using the data validation
function. Is there a way that I can set up the list so that the user is able
to chose more than 1 choice from my list? You see this on websites often.
I am trying to set up dropdown lists in MS Excel using the data validation
function. Is there a way that I can set up the list so that the user is able
to chose more than 1 choice from my list? You see this on websites often.
Using data validation, you can select multiple items with some
programming. There's an example here:
http://www.contextures.com/excelfiles.html
Under 'Data Validation', look for 'Select Multiple Items from Dropdown List'
microchick wrote:
> I am trying to set up dropdown lists in MS Excel using the data validation
> function. Is there a way that I can set up the list so that the user is able
> to chose more than 1 choice from my list? You see this on websites often.
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
Maybe you can pick up something from Debra Dalgleish's sample workbook:
http://www.contextures.com/excelfiles.html#DataVal
Look for:
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.xls 39kb
microchick wrote:
>
> I am trying to set up dropdown lists in MS Excel using the data validation
> function. Is there a way that I can set up the list so that the user is able
> to chose more than 1 choice from my list? You see this on websites often.
--
Dave Peterson
Thank you. So other than programming it in with virtual basic, there's no
easy way to do it? I looked at the code and think it's out of my skill
level...and it looks like a simple copying of the text won't do the job. Any
suggestions?
"Debra Dalgleish" wrote:
> Using data validation, you can select multiple items with some
> programming. There's an example here:
>
> http://www.contextures.com/excelfiles.html
>
> Under 'Data Validation', look for 'Select Multiple Items from Dropdown List'
>
>
> microchick wrote:
> > I am trying to set up dropdown lists in MS Excel using the data validation
> > function. Is there a way that I can set up the list so that the user is able
> > to chose more than 1 choice from my list? You see this on websites often.
>
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>
>
No, I don't know of any non-programming way to allow multiple selections
from a data validation list. Perhaps you could use the same list in
multiple columns, and allow users to select one in each column.
microchick wrote:
> Thank you. So other than programming it in with virtual basic, there's no
> easy way to do it? I looked at the code and think it's out of my skill
> level...and it looks like a simple copying of the text won't do the job. Any
> suggestions?
>
> "Debra Dalgleish" wrote:
>
>
>>Using data validation, you can select multiple items with some
>>programming. There's an example here:
>>
>> http://www.contextures.com/excelfiles.html
>>
>>Under 'Data Validation', look for 'Select Multiple Items from Dropdown List'
>>
>>
>>microchick wrote:
>>
>>>I am trying to set up dropdown lists in MS Excel using the data validation
>>>function. Is there a way that I can set up the list so that the user is able
>>>to chose more than 1 choice from my list? You see this on websites often.
>>
>>
>>--
>>Debra Dalgleish
>>Excel FAQ, Tips & Book List
>>http://www.contextures.com/tiptech.html
>>
>>
>
--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks