date stamping

  • I need to automatically enter a date into a purchase order form when the blank template is initially opened. But, I need that date to stay as the date the purchase order was then completed not the current date, so this makes the NOW function of no use as it will always return todays date!!!
    Please help I'm getting bald patches where I'm tearing my hair out!!

  • paspoard,

    You could write a macro that pastes the value and overwirtes the formula when the workbook is closed??

    So say if the formula =NOW() is in A1

    Private Sub Workbook_BeforeClose(Cancel As Boolean)
    Range("A1").PasteSpecial Paste:=xlValues
    End Sub

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!