Capturing timestamps of data entry within cells?

[aaron.irvine]

I'm wondering if it's possible to capture timestamps of when a user enters data in specific cells?

My novice idea was to use the Now() function within a for loop to record the time into a variable of any cell change, and repost that to an offset location within the same sheet (ideally it'd be written to a seperate file hidden from the users knowledge - yes I'm being sneaky!)

I've got a terrible piece of code that doesn't work - you can all laugh at it

Please Login or Register  to view this content.

A lot of the cells are hidden, and some of them are locked, so I wanted to reduce the number of cells it checked through every time the worksheet changed - hence the multitude of if statements. I couldn't get the offset function to work, but my MsgBox worked - hurrah.

I'll leave it to the experts to point out my mistake!

Thank you so much guys

[:) Sixthsense :)]

May be try something like this….

Copy the below code and do right click on sheet tab and select view code and paste it. Return to excel and check

Please Login or Register  to view this content.

[aaron.irvine]

Thanks for your help Sixthsense - that code only appears to be posting a single timestamp in column AL of a given row.

I need it to post the timestamps of every cell that is updated within the A5:AB249 range effectively in an offset range of say CA5:DB249 for example.

[aaron.irvine]

Got it to work!!

Please Login or Register  to view this content.