View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier[_3_] Roger Govier[_3_] is offline
external usenet poster
 
Posts: 2,480
Default 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.