Doing an audit trail on multiple sheets

I applied the code on two sheets and it seems running fine:

Please Login or Register  to view this content.

Regards,
Antonio

Thanks sooo much! it works!=)

Hi again, sorry to resurface the problem again. but i tried the codes and it works well with multiple sheets now. But the only problem is that it does not capture the 'changed from'. For example when i open a new workbook, type in 'boy' on cell $A$1 and then changed it to 'girl' on the same cell, it reflects:

User 1- sheet: Sheet1 - changed cell $A$1 from to boy
User 1- sheet: Sheet1 - changed cell $A$1 from to girl

With the previous code it captures the 'changed from' such as

User 1 changed cell $A$1 from boy to girl

Is omitting the code below the reason for this problem?

Please Login or Register  to view this content.

Excuse me but the code over is always necessary.
You need to insert all this code in each sheet:

Please Login or Register  to view this content.

Regards,
Antonio

Hello Antonio,

Thanks alot it works!=)

Dear Antonio and Nett,

I am new to writing macros in Excel and Visual Basic. I tried using the macro below, but where will it display the change information? Will this work on all cells in a macro enabled workbook? Thanks in advance for your help.

Best regards,
Gene

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Value <> PreviousValue Then
Sheets("log").Cells(65000, 1).End(xlUp).Offset(1, 0).Value = _
Application.UserName & " - sheet: " & ActiveSheet.Name _
& " - changed cell " & Target.Address _
& " from " & PreviousValue & " to " & Target.Value
End If
End Sub

Private Sub Worksheet_SelectionChange(ByVal Target As Range)
PreviousValue = Target.Value
End Sub

I used the sub and it works but when I select multiple cells and change them I get a runtime error 13, type mismatch.
How can this be avoided?

I hope this doesn't break any forum rules. I adapted this post for my uses and thought I'd add my version incase it's handy for anyone else.
I've added a very simple error handler to prevent it complaining if a merged cell or multi cells are clicked on. I also split the log details up in to their own column to make it slightly easier to read (IMO). I also added a date/time stamp.
Thanks to the author.

Please Login or Register  to view this content.