Track changes in a cell

  • Thread starter Thread starter gilbert
  • Start date Start date
G

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
 
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
 
Back
Top