How to record changes to cell values including time stamp

I was able to get it to work. The problem I had was because I already had a Private Sub Worksheet_Change. When I put yours in I changed the name but it would not run. When I added it to my existing Sub it ran. A few follow up questions:

Is there a way to rename it so that it does not have to be part of my existing sub? It is impacting the way my other Sub works. Whenever I change the name it doesnt run.

To add to the existing code, I would like to include the name of the change in column E on Sheet2. The names of the values from Sheet1 are Status, Target, Range (columns F, G, and H respectively). So for example, if a value in Sheet1 changes in column F, it would provide the information the Sub already does but also put "Status" in the appropriate row in column E.

Thanks.

Any thoughts?

Jeff - I have attached an example. What your sub did was perfect, I just also want it to include the heading for that column (F2, G2, or H2) when the value in that column changes.

As far as the code, you can see in the sub that I already have code that pops up a confirmation box when a value is changed in columns F:H. The issue I am having is that when I insert your code into mine, the 2nd sub (Private Sub Worksheet_SelectionChange) does not seem to run and therefore the option of "No" when asked to change does not work right (it makes the cell blank instead of putting the old value back in).

Jeff - thanks for the update. It seems to work correctly with only one issue. After the confirmation box pops up on a change, if you press No, it still changes the value (rather than revert back to the previous value).

That seems to work perfectly. I will play with it and see what happens.