Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Decreasing Validation List - Excel 2003
Okay...I have a validation list set up to select names from a named range on
a different sheet. No problem there. What Id like to do it is reduce the selection of names from the list once a selection has been made; but only for a selected column!! For example, if the list is of names and it has Tom, Rob, and Fred in it, if the user selects Rob from the list, and if the list is accessed again in the same column, Rob does not appear as an option to select again. Alright.....I have a VB code that will automatically remove the selected item from the drop-down validation list once it has been selected once. However, the particular code Im using only allows each name in the range to be used only once anywhere that the list is called. If actually removes the selected reference from the original named list permanently! This is my problem; I do not want the original named list deleted. I want the validation list of choices to reduce. The reason is that I want to use the named list in other places, with additional validation lists (again to select from the original list). I could simply make x-number of hidden copies of my original named list but that seems counterproductive. Is there a way to modify the VB code that it just temporarily reduces the visible selections until a new column is selected? I have uploaded a copy of a sample file from which am working (http://campus.pc.edu/~rarts/validation_test.xls). Basically, on the results page, Id like to be able to select names from my list for a particular column (Event #), switch columns (Events) and be able to pick from my original list again until used up for that column, and etcetera....can anyone help? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003. Data/Validation/Settings - Allow/List: sizing list? | Excel Discussion (Misc queries) | |||
Excel 2003-Data Validation drop down list not working? | Excel Worksheet Functions | |||
data validation when list is on a different worksheet? 2003 | Excel Discussion (Misc queries) | |||
Make Validation List Wider - Excel 2003 | Excel Discussion (Misc queries) | |||
Decreasing number of Values in Pivot Tables Value List | Excel Discussion (Misc queries) |