+ Reply to Thread
Results 1 to 15 of 15

Stop Today Date Function From Updating When Coping Text

  1. #1
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Stop Today Date Function From Updating When Coping Text

    Hello all

    Kindly help me in below code.

    Please Login or Register  to view this content.
    The code function is: when entering text in column H; automatically the cell in column E is filled with today date.
    It is ok till now

    But when

    I return to old data for old dates
    For example, the date in Cell E is 01/01/2016
    When I try to copy the text from cell H the date automatically returns to today date (18/03/2016) in Cell E and that is what I don’t want.

    I want the date to return to today date only if I add new text or delete some words form that text.

    And when coping entered text, I need the today date to be the same without any change or update.

    Hope it is clear

  2. #2
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Stop Today Date Function From Updating When Coping Text

    Hello Stoicy from Yemen الخليفي

    try this
    Please Login or Register  to view this content.
    < ----- Please click the little star * next to add reputation if my post helps you
    Visit Forum : From Here

  3. #3
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    hello Mr.Yasser

    I am very glad that you are here My great teacher

    I put the code

    But when I try to copy the text in cell H the date is change automatically to today date.

  4. #4
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    attached file
    Attached Files Attached Files

  5. #5
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Stop Today Date Function From Updating When Coping Text

    I tried the code again and it is ok for me..If I copied any cell and pasted it on column H the change of the date doesn't fired

    You may double clicked in the cell you need to copy ..this will fire the change

  6. #6
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    Sorry maybe there is misunderstanding

    maybe it is my weak language

    I mean to copy from H cell not to H

    I will give example:

    Yesterday I entered new text in column H
    and automatically the today date appears in column E which is 18 Mar

    today I enter new data

    later on I need to copy yesterday text from column H to use it in another file.
    the problem when I copy from H; the date in column E changed from yesterday date which is 18 Mar to be today date which is 19 Mar (which I don't want)

  7. #7
    Forum Expert
    Join Date
    04-23-2009
    Location
    Matrouh, Egypt
    MS-Off Ver
    Excel 2013
    Posts
    6,882

    Re: Stop Today Date Function From Updating When Coping Text

    It is supposed not to trigger the change if you copy FROM column H .. That's weird
    Waiting for experts' reply in this issue

  8. #8
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    I really appreciate your time spending for help and I get benefit from your code

    thank you Mr.Yasser

  9. #9
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    Any body know the answer please help

  10. #10
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    Any expert have the time to look at the above code

  11. #11
    Forum Expert nilem's Avatar
    Join Date
    10-22-2011
    Location
    Ufa, Russia
    MS-Off Ver
    2013
    Posts
    3,377

    Re: Stop Today Date Function From Updating When Coping Text

    Hi stoicy
    I mean to copy from H cell not to H
    How do you copy the data? Are you using Ctrl+C Ctrl+V?

  12. #12
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    Hello nilem

    Normally I use the mouse to copy form H, but I am not the only user for this file; it means other users may use Ctrl+C

  13. #13
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    Hello Gentlemen

    can anybody help, or excel VBA is not capable to deal with such issue?

  14. #14
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    Is it hopeless case?

  15. #15
    Registered User
    Join Date
    03-13-2016
    Location
    Yemen
    MS-Off Ver
    2016
    Posts
    59

    Re: Stop Today Date Function From Updating When Coping Text

    Hello everybody

    At last I found the solution and I like to share it with you

    Please Login or Register  to view this content.
    Many thanks for the nice people who do their best and try to help me from the beginning especially Mr.Yasser

    Thank you
    Last edited by stoicy; 03-24-2016 at 05:29 PM.

+ 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. Stop today function from updating daily
    By ExcelGuroo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-18-2015, 01:44 PM
  2. Please help me with VBA code to stop data updating using today's date.
    By Vickymabo in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 08-10-2015, 05:54 PM
  3. Looking for VBA code to stop data updating using today's date.
    By Vickymabo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2015, 02:34 PM
  4. Looking for VBA code to stop data updating using today's date.
    By Vickymabo in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-10-2015, 02:30 PM
  5. [SOLVED] How to stop "today" function from changing the date every day in excel
    By Haneen H in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-21-2013, 12:25 PM
  6. Help with automatic chart updating/auto updating today function
    By Tux2424 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 09-26-2012, 04:45 PM
  7. [SOLVED] How do I stop today() from updating date on saved spreadsheets?
    By lionmark in forum Excel General
    Replies: 2
    Last Post: 01-03-2005, 09:06 PM

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