| Home |
| Search |
| Today's Posts |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Reset Validation lists to display 1st value in list
The validation list only works on what is manually entered. Values already
in the cell are not affected. activecell.Value = Range("List")(1).Value would put the first item in the named range "List" as the value of the cell. -- Regards, Tom Ogilvy "Matt.Russett" wrote: I have a large amount of validation lists that are updated with a macro. However when I update the source of the list the value that is currently selected in the list stays the same. Is there some code I could add so my macro will not only update my source data but also reset each validation list to display the top value? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display part of list dependant on Validation list selection | Excel Worksheet Functions | |||
| Reset Validation cells to first list value | Excel Discussion (Misc queries) | |||
| Lists for List Validation | Excel Discussion (Misc queries) | |||
| Validation List - Reset to Top Value? | Excel Programming | |||
| Data Validation lists display bottom vs top | Excel Discussion (Misc queries) | |||
Threaded Mode
