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.

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.

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.

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

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.

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.

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.