Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple selection from and into validated cell.
Hi
How could i select more than one list item from drop down in validated cell/cells?? i'm having another sheet, where one list has been created with items to be displayed in drop down list of validated cell. *List:- Ram Rom CPU Mother board *desired output in validated cell is/are Ram, CPU, Mother board. would be looking for any related concern. Regards Vikas Kumar. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple selection from and into validated cell.
Try Debra's sample on "Select Multiple Items from Dropdown List" at:
http://www.contextures.com/excelfiles.html 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vikas Kumar" wrote: Hi How could i select more than one list item from drop down in validated cell/cells?? i'm having another sheet, where one list has been created with items to be displayed in drop down list of validated cell. *List:- Ram Rom CPU Mother board *desired output in validated cell is/are Ram, CPU, Mother board. would be looking for any related concern. Regards Vikas Kumar. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple selection from and into validated cell.
Thanks a lot Max...It's exactly what i wanted. just i need to do some
modifications in code. thanks once again Vikas Kumar. "Max" wrote: Try Debra's sample on "Select Multiple Items from Dropdown List" at: http://www.contextures.com/excelfiles.html 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vikas Kumar" wrote: Hi How could i select more than one list item from drop down in validated cell/cells?? i'm having another sheet, where one list has been created with items to be displayed in drop down list of validated cell. *List:- Ram Rom CPU Mother board *desired output in validated cell is/are Ram, CPU, Mother board. would be looking for any related concern. Regards Vikas Kumar. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple selection from and into validated cell.
You're welcome, Vikas !
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vikas Kumar" wrote in message ... Thanks a lot Max...It's exactly what i wanted. just i need to do some modifications in code. thanks once again Vikas Kumar |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple selection from and into validated cell.
Hi Max:
I downloaded Debra's sample in order to select multiple items from dropdown list. However, when I opened her file in Microsoft excel 2007 version, her macros didn't work. Whenever I put an entry, it only accepts a single selection. What do I need to do? "Max" wrote: Try Debra's sample on "Select Multiple Items from Dropdown List" at: http://www.contextures.com/excelfiles.html 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vikas Kumar" wrote: Hi How could i select more than one list item from drop down in validated cell/cells?? i'm having another sheet, where one list has been created with items to be displayed in drop down list of validated cell. *List:- Ram Rom CPU Mother board *desired output in validated cell is/are Ram, CPU, Mother board. would be looking for any related concern. Regards Vikas Kumar. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple selection from and into validated cell.
Hi
When I loaded the file in Xl2007 and tried to use it, I got a Code Interruption dialogue appear. Click continue and it works fine. I found this happened with several, but not all of the routines within the workbook. Having closed the file, and then re-opened, I cannot repeat the problem. I have looked at the code, and cannot spot anything obvious that would cause the problem. I have emailed Debra privately to inform her about this. -- Regards Roger Govier "Tiger" wrote in message ... Hi Max: I downloaded Debra's sample in order to select multiple items from dropdown list. However, when I opened her file in Microsoft excel 2007 version, her macros didn't work. Whenever I put an entry, it only accepts a single selection. What do I need to do? "Max" wrote: Try Debra's sample on "Select Multiple Items from Dropdown List" at: http://www.contextures.com/excelfiles.html 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vikas Kumar" wrote: Hi How could i select more than one list item from drop down in validated cell/cells?? i'm having another sheet, where one list has been created with items to be displayed in drop down list of validated cell. *List:- Ram Rom CPU Mother board *desired output in validated cell is/are Ram, CPU, Mother board. would be looking for any related concern. Regards Vikas Kumar. |
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
Multiple selection from and into validated cell.
Hi Roger:
Thanks for this post. It was helpful. I downloaded the file a 2nd time and it worked OK. The only thing I had changed was that I enabled all macros in excel before downloading and opening the file. Thanks. Tiger "Roger Govier" wrote: Hi When I loaded the file in Xl2007 and tried to use it, I got a Code Interruption dialogue appear. Click continue and it works fine. I found this happened with several, but not all of the routines within the workbook. Having closed the file, and then re-opened, I cannot repeat the problem. I have looked at the code, and cannot spot anything obvious that would cause the problem. I have emailed Debra privately to inform her about this. -- Regards Roger Govier "Tiger" wrote in message ... Hi Max: I downloaded Debra's sample in order to select multiple items from dropdown list. However, when I opened her file in Microsoft excel 2007 version, her macros didn't work. Whenever I put an entry, it only accepts a single selection. What do I need to do? "Max" wrote: Try Debra's sample on "Select Multiple Items from Dropdown List" at: http://www.contextures.com/excelfiles.html 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 -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "Vikas Kumar" wrote: Hi How could i select more than one list item from drop down in validated cell/cells?? i'm having another sheet, where one list has been created with items to be displayed in drop down list of validated cell. *List:- Ram Rom CPU Mother board *desired output in validated cell is/are Ram, CPU, Mother board. would be looking for any related concern. Regards Vikas Kumar. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|