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

Guest

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

Similar Threads

Data Validation List (conditional) 2
How to Update Selections for (Numerous) Validation Lists 1
get Data Validation to stop, list supplied, duplicate data entries 1
Validation List 7
VBA to sort list automatically in alphabetical order 6
data validation list 1
Use VBA to reset data validation (=list) value to first value in that list (list is a named range) 7
Hide column based on data validation 0

Top