Macro to date stamp date & ime

[howard]

I would like to add macro code to to show the last date and time stamp on Sheet "TBTXT" in cell D2 when a file is last imported for eg

Import File Datestamp: 22/03/13 12:41 (date must be in format dd/mm/yyyy0


Your assistance in this regard is most appreciated

 

[GaryOfah]

Hi!

It should be something on these lines...
Code goes under sheet.Right click on sheet -->add code.

Private Sub Worksheet_Change(ByVal Target As Range)

' you need to add more code
Range("D2") = Time()

End Sub

see also:
Worksheet Change Event: Run Excel Macros When a Cell Changes Or User Enters Data


2.Maybe even you can be satisfied with formula?
But I am not sure if that is possible...

You can try to format time/date cell as you like, on the sheet directly or in the code.

 

[howard]

Thanks for the reply and your assistance in this regard