RKFerguson
04-22-2016, 06:21 PM
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
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