+ Reply to Thread
Results 1 to 2 of 2

Cannot get time stamp to stay static

  1. #1
    Registered User
    Join Date
    Silver Spring, MD
    MS-Off Ver
    Excel 2003

    Cannot get time stamp to stay static


    I searched the internet for a solution to my problem and thought I had it, but now that it's a month later and I went to check on my spreadsheet, I realize that my function no longer works.

    When I enter text in Column C, I want column A to record the date of the entry. I want this time stamp to remain static.

    This is what I have currently:

    So that basically if C3 is empty, no time stamp appears. If C3 is full and a time stamp has already been generated in A3, A3 remains as A3 and is not updated.

    Not sure what the <> mean but I found it online written that way for this type of problem. When I substitute = for <> I get an error about the function.

    Any ideas as to how to get your time stamp to remain static for entries?

    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    New Jersey, USA
    MS-Off Ver

    Re: Cannot get time stamp to stay static

    The easiest way is to insert the folloiwng in your Worksheet_Change event macro.

    Please Login or Register  to view this content.
    It appears that you already have somehting in that macro that references a worksheet "UCAs". If that's the case then insert the highlighted lines as shown in the begining.

    In your attached file the formula you have in column A have circular reference, so they won't work anyway.


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1