MrExcel Publishing
Your One Stop for Excel Tips & Solutions

DAX ! This is Jill ! I still need your help !

Posted by Jill on August 22, 2001 9:37 AM

OK I inserted the code but where is the date hour and seconds displayed now?

Posted by Dax on August 22, 2001 2:04 PM

Try this slightly different approach...

Open the VB Editor (alt+F11)
Click View, Project explorer
Double click the ThisWorkbook icon in the project explorer (you may have to expand the tree)

Now assume you have a sheet named Expenses and you want to record the last saved date & time in cell C3 on this sheet. Use this code

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
Sheets("Expenses").Range("C3").Value = Format(Now(), "dd/mm/yy hh:mm")
End Sub

Does that help?


Posted by Dax on August 22, 2001 2:06 PM

Follow up

Forgot to add. The date and time will be added once you click Save.

Posted by jill on August 25, 2001 10:29 AM

Re: Follow up

ok that's what I forgot to it !

Thank you Dax, You are so nice