View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
Tiger Tiger is offline
external usenet poster
 
Posts: 21
Default 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.