Keep Log Of Cell Changes

Operation: The operator can obviously change any cell on the sheet, what I want to do is capture the value of the cell before the data is modified and the new just entered value.

Question:
Is there any simple way of doing this?

Accessing the Excel Undo stack perhaps?

Or does it take writing code coordinating the Worksheet_SelectionChange and Worksheet_Change events to capture the before data when the SelectionChanges in anticipation that it's going to be modified and identified in the Worksheet_Change event.

Re: Create A Modified Data Log With Before And After Values

Thanks Mac.

The idea of the modification log is to see who changed what and when, over time. The shared workbook is a good idea but doesn't apply in this case.

Re: Create A Modified Data Log With Before And After Values

Thank you.

Seeing the example it's easier than I was thinking it was going to be.

I was going for a much more complex solution. Thanks.

Re: Keep Log Of Cell Changes

It seems obvious now, but since I don't work with Tracking Changes very often, I hadn't thought of that as a way of accomplishing what I need. Thanks!

Re: Keep Log Of Cell Changes

This is an extension of my previous posting.

I have incorporated code to capture the original value(s) when Workbook_SheetSelectionChange (W_SSC) is invoked.

And log both the original value(s) and the current values(s) when
Workbook_SheetChange (W_SC) is invoked.

Now the problem:
The operator clicks in a cell, W_SSC is invoked and the original value is captured.
The operator changes the value, then without doing anything to invoke the W_SC, drags the value down several rows, which changes the values, and stops.
W_SSC is invoked and captures the changed values.
W_SC is invoked and compares what is supposed to be the original values to the current values and of course they match.

Is there a way around this?
Besides telling the operator don't do that?

Re: Keep Log Of Cell Changes

Bump