Results 1 to 2 of 2
  1. #1
    2 Star Lounger
    Join Date
    Jan 2004
    Thanked 0 Times in 0 Posts

    Automatic entry (2000)

    Hello Gurus,

    While Steve has answered my query regarding how to put a date stamp automatically. Can some one help me as to how to add the below to the worksheet.

    You could add something like this the thisworkbook object:
    Private Sub Workbook_Open()
    With Worksheets("Sheet1")
    .Range("A2").Value = .Range("A1").Value
    .Range("A1").Value = Now
    .Range("A1").NumberFormat = _
    """Opened Now: "" mm/dd/yyyy hh:mm"
    .Range("A2").NumberFormat = _
    """Last Opened: "" mm/dd/yyyy hh:mm"
    End With
    End Sub

    It will read the last opened date/time from A1 and put it into A2, then put the current date/time in A1. it formats as time with the "verbiage" to explain the date.
    Change the worksheet, ranges, and formatting as desired


  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Thanked 28 Times in 28 Posts

    Re: Automatic entry (2000)

    This question belongs in the thread starting at <post#=337295>post 337295</post#>. Since it has also been asked (and answered) there, I am closing this thread to avoid confusion.

    Please post any replies in the thread mentioned above. Thank you.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts