Record type of cell editing

[patact]

How can I capture how a cell was edited (i.e., contents deleted, content added, contents formated, etc) using vba?

I have written code that succesfully records the username, computer name, and cell(s) reference changed. Now I want to also capture 'how' the same cell was changed. I am using this for tracking purposes using the worksheet_change property.

[Mallycat]

I think you may have to keep a duplicate sheet and reference the difference. Shouldn't be that hard. Just trap the change event on the work sheet to first compare with the reference sheet, the commit the changes in the main sheet back to the reference sheet.

[patact]

There must be an easier way. I already track the changes (username, computer name, cell changed, and new contents of the cell changed). I just want to record one more item and that is the type of change that occured. For example, if a cell originally had some content (say a formula) and the formula was changed, I want to record something like formula changed in addition to the data above. I am tracking every change to a specific sheet and incrementally increasing the recorded information on another sheet row by row starting at Row 1 so that I have a complete history of all the changes over time. I automatically save the file each time a change is recorded and my summary sheet is very hidden so nobody can see it.

[patact]

Well I know there has to be someone smart enough out there to record this one last piece of information.......please help