Timestamp each time a cell value changes

Is there a way to make a time stamp (date, minutes, seconds) when a cell value is changed? And that's a "cell value" that is determined by a formula.


It can be like this:
------------------------------
A1 Formula with value
A2 Timestamp here, every time the value changes.


Thanks!

No, you could only do that with vba.

A formula timestamp would change every time recalculation occurs, even if the precedent cell is unchanged.

Ok. I don't know what "vba" is... but can you help me with that so I can try it out?

1. Sorry... I'm not purposefully trying to waste anyone's time, including mine. On the contrary, I tried asking for as little as possible, because I planned to edit the rest of the code myself. I figured that part would be easy for me to do. Before you even suggested it, I adjusted "A1" to be "A6:A260" (That's all I know about coding)... BUT it's not working that way. It only works for one cell at a time... Is there another way to code that in there?

2. Also, as I mentioned before.... what about the "value" of the cell changing from being "" BLANK.... to not being blank.

---------- Post added at 05:23 PM ---------- Previous post was at 05:21 PM ----------

Here's what I did to the code.....

Please Login or Register  to view this content.

Thanks for your patience!!!

Ok... Almost there... Now it does a timestamp when Column A has a regular formula like =SUM(B6:D6) and value changes... or when i type something in manually.
However, it still DOES NOT do a timestamp with the formula I use now. Which make Col A either be "" BLANK or "FILLED"... (Example of cell A formula... =IF(B6=0;"";B6)

So, perhaps something in the code to search for the condition: WHEN cell is A = "" BLANK then timestamp... AND WHEN cell A = "FILLED WITH A VALUE" also timestamp....
If that can work, then it will be perfect! Thanks again!!!!

By the way... an error also pops up with the macro. And when I click on "Debug" it highlights this reference in yellow:

Please Login or Register  to view this content.

And I know that piece of code is in there twice. The top one, or the first reference is highlighted. Thanks!

By the way... an error also pops up with the macro. And when I click on "Debug" it highlights this reference in yellow:

Please Login or Register  to view this content.

And I know that piece of code is in there twice. The top one, or the first reference is highlighted. Thanks!

Originally Posted by nenadmail

=IF('Annual Items'!R5=0;"";'Annual Items'!R5)

Our solutions are only as good as your examples. The code is not being triggered because the target is in a different sheet.

You would need to enter the code into the "Annual Items" code module and qualify the ranges with a reference to the sheet holding the timestamp.

Once corrected this might work, I'm lost trying to figure out from your many different examples what you're working with.

The method of coding required is specific to the content of the cell, as you're finding out, what is written for one scenario doesn't always work with another, in general, values need a change event, formula need calculate, but in your case to track specific formula changes, you need to look at changes in precedent cells (the cells that you change that will cause the formula to recalculate).

Hi,

This is my first time posting. For the code below, it records a new date stamp in row 2 and its respective column if a cell value in row 1 changes. How do I repeat it for row 5? Let say I have a second set of values on row 5 that I want to see a new date stamp on row 6 if values on row 5 changes.

Private Sub Worksheet_Change(ByVal Target As Range)
Dim V As Variant
If Not Intersect(Target, Rows("1:1")) Is Nothing Then
Application.EnableEvents = False
For Each C In Intersect(Target, Rows("1:1"))
Application.Undo
V = C.Value
Application.Undo
If Not IsEmpty(C) And V <> C Then
C.Offset(1, 0).Value = Now
End If
Next C
Application.EnableEvents = True
End If
End Sub


Thanks

Hi Richard,

First time poster here. I've seen many users trying to timestamp when a cell value changes, and the timestamp VBA codes can do that *only* when the cell value is changed manually.

Is there a way to alter the VBA code you've shared so that a timestamp will appear when Target Cell's value changes WHEN THE CHANGE IS THE RESULT OF A REFERENCE (i.e. =Sheet2!A1)?

Thanks

Hi arwebb0264,

It looks like, as a new member, that you may not be aware of the basic rules that all members are required to follow, please take a moment to read them (there is a link to them in the header at the top of this page).

Hi Jason,

I don't understand - it seems as though you think I am cross-posting, but I am not. The problem I posted is actually the crux of nenadmail's issue, too.

And the posters seem not to get that, so I was trying to rephrase reiterate. If I am mistaken, I apologize. Thanks!

Sorry, I should have been more specific, I was actually referring to rule #2,

Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.

Oh okay, thanks for the heads-up.