Adding Time Cell Was Changed

A

Andy Rads

Column A has different values (these are not important). In column B I want
to show the time that say cell A1 was changed. I have tried several methods
but all result in all the times in column B being changed to the same time.
Can anyone help?

Many thanks.
 
H

Héctor Miguel

hi, Andy !
... In column B I want to show the time that say cell A1 was changed.
I have tried several methods but all result in all the times in column B being changed to the same time...
Click to expand...

here is another approach, defining/using a [tricky] UDF as follows:

Function Change_Time(myCell As Range) As Date
Volatile = False
Change_Time = Now
End Function

you could use the above UDF [i.e.] in 'B1'...
=if(a1<>"",change_time(a1))

you might need to format 'B1' like: h:mm:ss.0000

hth,
hector.
 
Top