Urgent question regarding LIST
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 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 |
Urgent question regarding LIST
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 |
Urgent question regarding LIST
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 |
All times are GMT +1. The time now is 12:21 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com