A Time Stamp Formula!

  • Thread starter Thread starter Aymanh
  • Start date Start date
A

Aymanh

Does any body know about a formula that can time stamp the changes in other
cells?
 
Hi Aymanh

You need VBA to do that

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


Manual you can do this

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
 
Have a look at an answer from Gord Dibben on 11 10 03 in excel functions
copied below.............
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Time Stamp 1
Creating custom stamps in .pdf Adobe documents 1
separating date and time 5
Time Stamp formula 5
making NT user/login user appear in a cell 1
How do I lock a stamp date/time formula for an entry on a row? 3
Date & Time Stamp for printing 1
time stamp 2

Back
Top