Track changes in a cell

[gilbert]

Hi Hi...

Just wonder if we can count the changes in a particular cell?

For example, cell A1 is the date of revision, user will key in ... cel
B1 will count the number of time the date entered in cell A
changes....can we do that?

Please advise how if you know.....or please show me alternative way i
there is

 

[Peter Atherton]

Gilbert

This uses a cell value in sheet1 and increments it be 1
each time the book is opened.

Sub auto_open()
With Worksheets(1)
Range("A1") = Range("A1") + 1
End With
End Sub

Regards
Peter