Write Current Time Next To Changed Cell (without updating it)

[namialus]

Hi,

I need to record time next to eg.: W3 cell,
now i'm using below formula :

=IF(W3<>"",NOW(),"")

but the NOW function keep updating time itself,
is there any VBA code or function that I can use with this formula ?

[Bob Phillips]

Just enter Ctrl-; and space and Ctrl-:

[:) Sixthsense :)]

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

Close the VBA window (Alt+Q to close VBA window) and return to that sheet and check.

Please Login or Register  to view this content.

[6StringJazzer]

There is a sneaky way to do this with a circular reference, but before W3 is populated the value will be zero, not blank. That may not get you exactly what you want. You could add conditional formatting to hide the text when the value is zero.

This formula is put into X3:

Please Login or Register  to view this content.

[namialus]

Thank you guys,

I tried all 3 methods and all working just fine, just need to choose which one to use

Thank you again