Excel: VBA tracking. (VBA updates any changes made to worksheet.)
Posted on 2010-09-19
Normally I use Tools-->Track Changes --->Highlight Changes.
As you know this will show a note on each cell that is changed with the following information...
1) The users name
2) Time user made the change
3) A description of the change.
I would like to create VBA that does something similar. (I don't want to use "Track Changes"...)
Therefore....What VBA would I need so that every time a user makes a change to "Sheet1" of my Excel file, on Sheet 2 column A it will log in a cell the users name/computer name, current date and if possible the first 20 characters of the change.
i.e. if the user named "Bobby" goes to "Sheet1" and updates cell C1 to "Hello on 6/7/10" then updates cell E20 to "goodbye" on 8/1/10
the following information will show on "Sheet2" in columnA
Row1: 6/7/10, Bobby, "Hello"
Row2: 8/1/10, Bobby, "goodbye"