Reset Validation lists to display 1st value in list

  • Thread starter Thread starter Matt.Russett
  • Start date Start date
M

Matt.Russett

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?
 
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.
 
Back
Top