Amend the DV0022 - Update Validation Selections code for more lists

R

roniaelm

Hi,

I have used the following code to update cells that have already had
the original value selected from the data validation list if the value
in the data list has been changed.

http://www.contextures.com/excelfiles.html

Under Data Validation, look for 'DV0022 - Update Validation
Selections'

However, is it possible to amend this VBA code so that I can have this
code for a number of columns? I have three data validation lists set-
up in three different columns. I would like for the data to change in
the destination cell if any of the data in the data lists are changed.

I have tried to copy the code and change the data list name but that
did not work. I would appreciate any suggestions.

Thanks!
 
J

Joel

From the worksheet menu you need to change the Named Range of fruitlist.

Insert - Name - define - fruitlist
 

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

How to Update Selections for (Numerous) Validation Lists 1
Data Validation Update Validation Selection 5
Creating Data Validation Dependent Lists 2
update validation when change source 2
Data Validation Lists 5
Data Validation 1
Linked Lists / Data Validation - Excel 97 1
Data Validation lists update orginal cell with list update 3

Top