record changes to a worksheet

[franklinsam]

Let me begin by saying that I still a newbie with VB so I might appear to be bit dense at first.

I want to add the date, time and user id to an excel spreadsheet when any cell in the current worksheet changes. The spreadsheet has multiple tabs but I'm only interested if one specific worksheet changes. I understand that autosave will change saved date but that isn't what I'm looking for, I'm interested knowing when any cell in a specific tab changes. I would also like a log file in the same workbook to keep track of all changes.

Thanks

 

[franklinsam]

That works, thank you very much.

 

[Joe4]

You are welcome.
Glad we were able to get it working the way you want.