Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple selections from drop down list
Hello,
Firstly, I am a basic Excel user, alas coding etc means nothing to me. Please help, I have a drop down list where I woudl like it possible to select more than one option (tick box) I have gone to validation and have nothing that mentions "multiple". I have Excel 2003 and would really appreciate some help. Many thanks for taking the time to read my post |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple selections from drop down list
Hello,
I think you can use Validate=list. the list will be a range. for example, A12:A30 or A12:H12, both are ok. First, you may try with the list located in the same sheet. If you wan to put the list in another sheet, you have to define you list as a reference. Use insert=names=define=... and in validation=list=source, you should put "=reference name", the reference name is the name you defined before that. I don't know whether I really could help you. "Andyroo" wrote: Hello, Firstly, I am a basic Excel user, alas coding etc means nothing to me. Please help, I have a drop down list where I woudl like it possible to select more than one option (tick box) I have gone to validation and have nothing that mentions "multiple". I have Excel 2003 and would really appreciate some help. Many thanks for taking the time to read my post |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple selections from drop down list
Hi,
Thanks for the reply. I seem to be going in circles with that i`m afraid. Thanks anyway though. "ViestaWu" wrote: Hello, I think you can use Validate=list. the list will be a range. for example, A12:A30 or A12:H12, both are ok. First, you may try with the list located in the same sheet. If you wan to put the list in another sheet, you have to define you list as a reference. Use insert=names=define=... and in validation=list=source, you should put "=reference name", the reference name is the name you defined before that. I don't know whether I really could help you. "Andyroo" wrote: Hello, Firstly, I am a basic Excel user, alas coding etc means nothing to me. Please help, I have a drop down list where I woudl like it possible to select more than one option (tick box) I have gone to validation and have nothing that mentions "multiple". I have Excel 2003 and would really appreciate some help. Many thanks for taking the time to read my post |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple selections from drop down list
Andy
Go to Debra Dalgleish's site at http://www.contextures.on.ca/excelfiles.html#DataVal Scroll down to...................about 1/3 down the page 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. There is a downloadable *.ZIP file with example and code. Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 07:55:02 -0700, Andyroo wrote: Hi, Thanks for the reply. I seem to be going in circles with that i`m afraid. Thanks anyway though. "ViestaWu" wrote: Hello, I think you can use Validate=list. the list will be a range. for example, A12:A30 or A12:H12, both are ok. First, you may try with the list located in the same sheet. If you wan to put the list in another sheet, you have to define you list as a reference. Use insert=names=define=... and in validation=list=source, you should put "=reference name", the reference name is the name you defined before that. I don't know whether I really could help you. "Andyroo" wrote: Hello, Firstly, I am a basic Excel user, alas coding etc means nothing to me. Please help, I have a drop down list where I woudl like it possible to select more than one option (tick box) I have gone to validation and have nothing that mentions "multiple". I have Excel 2003 and would really appreciate some help. Many thanks for taking the time to read my post |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
multiple selections from drop down list
Hi, I found this file and the code - but now how do I make it work in my
spreadsheet? Karen "Gord Dibben" wrote: Andy Go to Debra Dalgleish's site at http://www.contextures.on.ca/excelfiles.html#DataVal Scroll down to...................about 1/3 down the page 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. There is a downloadable *.ZIP file with example and code. Gord Dibben MS Excel MVP On Mon, 10 Jul 2006 07:55:02 -0700, Andyroo wrote: Hi, Thanks for the reply. I seem to be going in circles with that i`m afraid. Thanks anyway though. "ViestaWu" wrote: Hello, I think you can use Validate=list. the list will be a range. for example, A12:A30 or A12:H12, both are ok. First, you may try with the list located in the same sheet. If you wan to put the list in another sheet, you have to define you list as a reference. Use insert=names=define=... and in validation=list=source, you should put "=reference name", the reference name is the name you defined before that. I don't know whether I really could help you. "Andyroo" wrote: Hello, Firstly, I am a basic Excel user, alas coding etc means nothing to me. Please help, I have a drop down list where I woudl like it possible to select more than one option (tick box) I have gone to validation and have nothing that mentions "multiple". I have Excel 2003 and would really appreciate some help. Many thanks for taking the time to read my post |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Choosing multiple items in a drop down list | Excel Discussion (Misc queries) | |||
Hide previously used items from multiple drop lists | Excel Worksheet Functions | |||
Hide previously used items from multiple drop lists | Excel Worksheet Functions | |||
Excel: Can you allow multiple selections from one list box? | Excel Discussion (Misc queries) | |||
CREATE MULTIPLE DROP DOWN LIST IN SAME WORKBOOK? | New Users to Excel |