+ Reply to Thread
Results 1 to 8 of 8

I Want the Timestamp Value Not to Change if the Name Cell Changed

  1. #1
    Registered User
    Join Date
    01-11-2013
    Location
    dammam
    MS-Off Ver
    Excel 2013
    Posts
    31

    Talking I Want the Timestamp Value Not to Change if the Name Cell Changed

    I have the bellow code to automatically generate a timestamp once the user typed their name in the cell next to the timestamp. the code works and does generate a timestamp. but if the user the next day changed the name, the code will regenerate a new timestamp which will replace the current one. which is defeat the main purpose of having a timestamp in the first place.
    So basically what I want is that, if there is a value in the timestamp cell, even if the name was deleted or modified, the timestamp does not change.
    Is that possible? please help.

    Please Login or Register  to view this content.
    Last edited by JBeaucaire; 09-07-2013 at 08:20 AM. Reason: removed broken link

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: I Want the Timestamp Value Not to Change if the Name Cell Changed

    @ Admin:

    Is this my weekend fever... or Attachment is really not working..
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    01-11-2013
    Location
    dammam
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: I Want the Timestamp Value Not to Change if the Name Cell Changed

    Quote Originally Posted by Debraj Roy View Post
    @ Admin:

    Is this my weekend fever... or Attachment is really not working..
    I was able to download it and open it

  4. #4
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: I Want the Timestamp Value Not to Change if the Name Cell Changed

    No Luck.. can someone check this for me.. except OP.. please..

    BTW.. in the meantime.. try this..
    Please Login or Register  to view this content.

  5. #5
    Registered User
    Join Date
    01-11-2013
    Location
    dammam
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: I Want the Timestamp Value Not to Change if the Name Cell Changed

    Quote Originally Posted by Debraj Roy View Post
    No Luck.. can someone check this for me.. except OP.. please..

    BTW.. in the meantime.. try this..
    Please Login or Register  to view this content.
    LOL. You are genius! it does work perfectly. I'll change it to solved. thanks Debraj Roy

  6. #6
    Registered User
    Join Date
    01-11-2013
    Location
    dammam
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: I Want the Timestamp Value Not to Change if the Name Cell Changed

    I have to say, you solved one other problem I was having by exposing me to "now()". I was only aware of "today()" which did not take the time into account.

    Thanks again for improving the code.

  7. #7
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: I Want the Timestamp Value Not to Change if the Name Cell Changed

    Hi Bssol..

    thanks for the feedback and appreciation...
    If you like to say thanks someone, you don't have to write anything.. just simply click the "Add Reputation" star.. to say "Thanks"

  8. #8
    Registered User
    Join Date
    01-11-2013
    Location
    dammam
    MS-Off Ver
    Excel 2013
    Posts
    31

    Re: I Want the Timestamp Value Not to Change if the Name Cell Changed

    Quote Originally Posted by Debraj Roy View Post
    Hi Bssol..

    thanks for the feedback and appreciation...
    If you like to say thanks someone, you don't have to write anything.. just simply click the "Add Reputation" star.. to say "Thanks"
    Even better, this is a new tip for me, you got my approval!.

    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Timestamp in Reference to a Change in Value of a Cell
    By martin4angelo in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 05-21-2012, 03:30 AM
  2. change values in a range when cell value is changed in that row
    By hattisaeed in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-31-2011, 09:14 AM
  3. Change cell value when sheet name changed
    By hesham63 in forum Excel General
    Replies: 3
    Last Post: 06-23-2010, 09:27 PM
  4. Cell value is changed, the cells change the color
    By lsuersoy in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 05-06-2010, 07:17 AM
  5. [SOLVED] change date only if cell is changed
    By zbor in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 03-24-2010, 09:16 AM

Bookmarks

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