Hello all,
How to get a timestamp whenever I save the file using the Now() function in my sheet named HSheet of cell C18. I tried the following code and it worked only once. How do I get a new timestamp each time I save my excel file.
Thanks and will appreciate.
How to get a timestamp whenever I save the file using the Now() function in my sheet named HSheet of cell C18. I tried the following code and it worked only once. How do I get a new timestamp each time I save my excel file.
VBA Code:
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Dim LValue As Date
LValue = Now
Worksheets("HSheet").Range("C18").Value = LValue
End Sub
Thanks and will appreciate.