Reset Validation lists to display 1st value in list

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?
 
T

Tom Ogilvy

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top