Time when an entry was made

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there any way to show what time an entry was made to a particular cell? I've tried using the NOW function within an IF statement but everytime I reload the worksheet it updates to the current time. What I would like to do is be able to make an entry, say in cell C3 and in cell A1 would be the date and B2 would be the time the entry was made. Then if I reopened the file in a couple of days the date & time would have stayed the same. Thanks
 
Hi
have a look at
http://www.mcgimpsey.com/excel/timestamp.html

--
Regards
Frank Kabel
Frankfurt, Germany

Dave B said:
Is there any way to show what time an entry was made to a particular
Click to expand...
cell? I've tried using the NOW function within an IF statement but
everytime I reload the worksheet it updates to the current time. What I
would like to do is be able to make an entry, say in cell C3 and in
cell A1 would be the date and B2 would be the time the entry was made.
Then if I reopened the file in a couple of days the date & time would
have stayed the same. Thanks
 
Hi Dave

You can use a Shortcut for it

you can insert the time like this
CTRL : (colon)

the date like this
CTRL ; (semicolon)

CTRL : (colon) space bar CTRL ; (semicolon)
this will give you both in one cell


Or with VBA

You can do it with the change event of the worksheet
This example will place the date/time in the B column if you change
a cell in the range A1:A20.

Place the code in the Sheet module

Right click on a sheet tab and choose view code
Paste the code there
Alt-Q to go back to Excel


Private Sub Worksheet_Change(ByVal Target As Range)
If Not Application.Intersect(Range("a1:a20"), Target) Is Nothing Then
Target.Offset(0, 1).Value = Format(Now, "mm-dd-yy hh:mm:ss")
End If
End Sub


--
Regards Ron de Bruin
http://www.rondebruin.nl


Dave B said:
Is there any way to show what time an entry was made to a particular cell? I've tried using the NOW function within an IF
Click to expand...
statement but everytime I reload the worksheet it updates to the current time. What I would like to do is be able to make an entry,
say in cell C3 and in cell A1 would be the date and B2 would be the time the entry was made. Then if I reopened the file in a couple
of days the date & time would have stayed the same. Thanks
 
Back
Top