Hello,
I have a list created in excel 2002, and I want to know if there is any way
to select more than one option from the dropdown. The excercise I am working
on, it might require me to select 2 or more options from dropdown. Is this
doable. Please help
Thanks

"Urgent question regarding LIST" <Urgent question regarding
wrote in message
...
Hello,
I have a list created in excel 2002, and I want to know if there is any
way
to select more than one option from the dropdown. The excercise I am
working
on, it might require me to select 2 or more options from dropdown. Is
this
doable. Please help
Thanks

I don't understand exactly what you want. Perhaps "dependent lists",
explained here?
http://www.contextures.on.ca/xlDataVal02.html

Assuming your dropdown list is from Data Validation you can select multiple
items using VBA code.

See Debra Dalgleish's site for a sample workbook.

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

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


Gord Dibben MS Excel MVP

On Mon, 3 Dec 2007 07:50:00 -0800, Urgent question regarding LIST <Urgent
question regarding wrote:

Hello,
I have a list created in excel 2002, and I want to know if there is any way
to select more than one option from the dropdown. The excercise I am working
on, it might require me to select 2 or more options from dropdown. Is this
doable. Please help
Thanks

Excel 2003 has a custom option where you can use multiple options with either
AND or OR. If 2002 has that option, try that.





"Urgent question regarding LIST" wrote:

Hello,
I have a list created in excel 2002, and I want to know if there is any way
to select more than one option from the dropdown. The excercise I am working
on, it might require me to select 2 or more options from dropdown. Is this
doable. Please help
Thanks