Tony,

The code below will keep track of the changes to cell A1, listing all the
values and the date/time changed. The list will start at the bottom of
column A -which will have the values, and column B will have the dates - and
progress down as changes continue.

Copy the code, right-click the sheet tab, select "View Code" and paste the
code in the window that appears.

HTH,
Bernie
MS Excel MVP

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Cells.Count 1 Then Exit Sub
If Target.Address < "$A$1" Then Exit Sub
Application.EnableEvents = False
Range("A65536").End(xlUp)(2).Value = Range("A1").Value
Range("A65536").End(xlUp)(1, 2).Value = Now()
Application.EnableEvents = True
End Sub


"Tony B" <Tony wrote in message
...
I want to be able to see a history of all the changes made to a specific
cell. Right now, I'm only able to see the latest change. It would be very
beneficial to me if I could see the full history of changes to one cell.
Thanks in advance for you help.