Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation Lists
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. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation Lists
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation Lists
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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation Lists
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 wrote: 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 -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Validation Lists
Thank you very much !
"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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to clear validation lists based on other validation lists | Excel Discussion (Misc queries) | |||
Data validation with validation lists and combo boxs | Excel Discussion (Misc queries) | |||
Using Lists/Validation | Excel Discussion (Misc queries) | |||
Validation lists | Excel Programming | |||
Validation lists | Excel Programming |