Document a change in value to cells in particular row

[maacmaac]

Is it possible to record a date and/or time when another cell in excel has been modified.

For example:

If a user changes the value of any cell in row A25:E25, I want to record the date the change was made in cell F25.

If a user changes the value of any cell in row A500:E500, I want to record the date the change was made in cell F500.

And so on. Thanks for any comments.

[Palmetto]

You would need to use VBA code in the worksheet module.
This code goes into the sheet module. Right-click the worksheet tab, choose View Code and copy and paste this entire code into the code pane,

It will place the current date into cell F25 or F500 when a change is made to any cell on the same row in columns A-E.

Please Login or Register  to view this content.