Amend the DV0022 - Update Validation Selections code for more lists

[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!

 

[Joel]

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

Insert - Name - define - fruitlist