Forum Discussion
Date of Last Modified for a Cell
Good day, all. I am inquiring if there is an excel function that would give me a date (and time) that an individual cell was last modified. For example: cell A2 has an entry of $2.55 and I'd lik...
Thank you! This is the expected behavior: the formula will only set the time stamp if there is no time stamp yet and the order status is changed to a non-blank value. After that, the time stamp will remain the same until the order status is cleared.
If you want the time stamp to be updated each time the order status changes, you cannot use a formula. It can only be done using VBA code. There are several examples of such code in this discussion.
Digging up an old thread but I can't seem to get the VBA to run
Starting with A2, I would like to update column A with a date when anything in columns B through L is changed
Make sure that:
- The code is in the worksheet module (right-click the sheet tab and select View Code from the context menu to activate this module)
- You save the workbook as a macro-enabled workbook (*.xlsm)
- You allow macros when you open the workbook