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?