I used the method that is in "http://www.contextures.com/xlDataVal02.html" ,
I have dependent lists ..... the problem here is that I had to create 85
lists in my excel file ... the functionality is working fine and even I have
included the functionality for adding items to my lists .... but I want to
know if this way is the best speaking about managment memory or if you
think that I would do it using source code .

Thank you

"Debra Dalgleish" wrote:

Selecting the best option depends how your source lists are set up.
There are a few variations on dynamic validation lists he

http://www.contextures.com/excelfiles.html

Maybe one of those would be better in your workbook.

Angeles wrote:
Hi , I have a question for you ..... I need to have dynamic Validation Lists
and I have implemented a solution that I found in this forum , using the
option in excel Insert - Name - Define I have defined my lists of values ,
but they are 85 posible lists , do you think that is the best option for
implementing this ? I refer to the managment memory and enhancement.

Thank you in adavance.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html