Watch cell?

[ljubo_gr]

Is there a way to monitor(watch) cell value changes w/o Watch window? Office2013. I have cell in witch i input raw data like let's say number 12345, i need formula or VBA sub to watch value changes and display me in other cell, date when was change occured, or if it's possible, days passed from change. Example: 12345 number was entered 2.6.2016., need to display days passed from 2.6.(8 days).

Thanks in advance. Thank you for your time and love for Excel!



P.s And if it's possible, non-volatile way. Thanks

Also asked: http://answers.microsoft.com/en-us/...tch-cell/12a5242e-08b4-47df-bdee-049b13b008db

http://www.ozgrid.com/forum/showthread.php?t=200064

 

[wideboydixon]

	A	B
Date last changed	Value

<colgroup><col style="width: 25pxpx"><col><col></colgroup><thead>
</thead><tbody>
[TD="align: center"]1[/TD]

[TD="align: center"]2[/TD]
[TD="align: right"]02/06/2016[/TD]
[TD="align: right"]0[/TD]

</tbody>

Sheet1​

Private Sub Worksheet_Change(ByVal Target As Range)


If Not Application.Intersect(Range("B2"), Target) Is Nothing Then
    Range("A4").EntireRow.Insert
    Range("A4").Value = Date
    Range("B4").Value = DateDiff("d", Range("A2").Value, Date)
    Range("A2").Value = Date
End If


End Sub

WBD

 

[ljubo_gr]

Maybe this:

Private Sub Worksheet_Change(ByVal Target As Range)

    If Not Intersect(Target, Me.Range("A1")) Is Nothing Then MacroM
    
End Sub

in sheet1

and module:

Sub MacroM()

    Range("B1").Select
    ActiveCell.FormulaR1C1 = "=(NOW()-RC[0])"


End Sub

B1 format as "dd-hh:mm"

 

[ljubo_gr]

Bump

 

[ljubo_gr]

bump