Update cell value on sheet change

[RKFerguson]

Hi Folks,

I am trying to update a cell's value when a change occurs to the sheet on which that cell resides.

I am leveraging a code snippet that I found from a web search - I have attached a test spread sheet.

Data validation rules for the cells in column K, present three choices from which the user may select.

It is a change to one of those cells that triggers the macro. I used a MsgBox to display the value of "Target.Address and, even when it displays K3, the remaining code does not update the value in cell L3.

Can you please help me determine why the code does not fire? I do not get an error message. The cell just does not change.


Thank you.

Fergie

[Bob Phillips]

There is no code in that file, there can't be, it is an .xlsx.

[RKFerguson]

I attached the wrong file. Mea culpa. But I do not see away to remove that file or to attach the correct one...

[Paul_Hossler]

Just attach the correct file to a new post