Validation Lists

[Guest]

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]

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

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

Maybe one of those would be better in your workbook.

 

[Guest]

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]

Without knowing how your workbook is set up, or the size of the lists,
or where the data validation is used, it's difficult to suggest the best
approach.

That's why I suggested that you look at the alternatives. Perhaps one of
those sample files will be similar to your workbook, and provide a more
efficient way to create and maintain the lists.

 

[Angeles]

Thank you very much !

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

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

Maybe one of those would be better in your workbook.