View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.misc
PK PK is offline
external usenet poster
 
Posts: 69
Default Automatic date stamping

Thats great, exactly what I was after.If I want to put a time stamp on it
also do I just enter time after the word "date".

Thanks again for your help
--
pk


"Gary''s Student" wrote:

It may be a formatting issue.

1. Remove the previous macro
2. Instert this one in its place:

Private Sub Worksheet_Change(ByVal Target As Range)
Application.EnableEvents = False
Range("A1").Value = Date
Range("A1").NumberFormat = "dd mmmm yyyy"
Application.EnableEvents = True
End Sub

--
Gary''s Student - gsnu200752


"PK" wrote:

It appears that every time I carryout an edit it changes the date date to a
different one none of which have been correct
--
pk


"Gary''s Student" wrote:

What is the date that you see in the cell and what is the date on your
computer??
--
Gary''s Student - gsnu200752


"PK" wrote:

Thank you for that however I find that the date being entered is incorrect
and does not match the date on my computer.

Thank you again
--
pk


"PK" wrote:

I Woukd like to a date stamp to to entered in to a cell within aspreadsheet
and refreshed each time the spreadsheet is updated.

Is this possible
--
pk