+ Reply to Thread
Results 1 to 8 of 8

Show today's date if specified cell is modified

  1. #1
    Registered User
    Join Date
    02-23-2012
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Show today's date if specified cell is modified

    Hello everyone - I hope somebody will be able to help me ;)

    I would like today's date to show in cell A1 if cell I47 is modified.

    Thanks a lot in advance!
    Last edited by xavpg; 02-28-2012 at 06:30 PM.

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Show today's date if specified cell is modified

    Hi,

    You'll need to add the following code to the Sheet change event in the Visual Basic Environment

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Show today's date if specified cell is modified

    Hi and welcome to the forum.

    In A1, try this.

    =IF(I47="";"";IF(A1="";NOW();A1))

    You use a circular reference to enter the date when a change is made in another cell.Choose Tools/Options/Calculation and check the Iteration checkbox to be 1. Not 100!.

    Change the semi-colos to gomma, if you have to do it.

    Hope it helps you.
    Regards

    Fotis.

    -This is my Greek whisper to Europe.

    --Remember, saying thanks only takes a second or two. Click the little star * below, to give some Rep if you think an answer deserves it.

    Advanced Excel Techniques: http://excelxor.com/

    --KISS(Keep it simple Stupid)

    --Bring them back.

    ---See about Acropolis of Athens.

    --Visit Greece.

  4. #4
    Registered User
    Join Date
    02-23-2012
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Show today's date if specified cell is modified

    I need further help about this. The VB code you provided Richard works, but my spreadsheet is linked to other spreadsheets. So, everytime I open the file, it asks me if I want to update the content and I click yes (since it's possible it has changed). The update makes the date change, even if the value didn't change. But I don't want the date to change if the value doesn't change... I hope it's clear. If you need more details, let me know

    Thanks again very much for your help!

    Xavier
    Montreal, Canada

  5. #5
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Show today's date if specified cell is modified

    ... The VB code you provided Richard works,....
    Yes, but in the meantime didn't you find one minute of free time to let Richard(and all of us) knows that his solution, works for you??

  6. #6
    Registered User
    Join Date
    02-23-2012
    Location
    Montreal, Canada
    MS-Off Ver
    Excel 2010
    Posts
    5

    Re: Show today's date if specified cell is modified

    Yes, but in the meantime didn't you find one minute of free time to let Richard(and all of us) knows that his solution, works for you??
    I did. I changed the thread subject by adding [SOLVED] in the subject. I read to do so in the Forum Rules. I removed the [SOLVED] when I began experiencing an issue again. I am very sorry if it is not the way to proceed; I am new to this forum and still learning how it works. In the future, I will not only change the subject line to [SOLVED], but also reply to the thread.

    Many thanks for your understanding and for your help,
    Xavier

  7. #7
    Forum Contributor
    Join Date
    02-08-2012
    Location
    South Suffolk
    MS-Off Ver
    Excel 2007
    Posts
    102

    Re: Show today's date if specified cell is modified

    Could you have a hidden cell that holds the old value in I47? Let's call it XX47
    Please Login or Register  to view this content.
    (I haven't tested this so some modification may be needed)

  8. #8
    Forum Expert Fotis1991's Avatar
    Join Date
    10-11-2011
    Location
    Athens(The homeland of the Democracy!). Greece
    MS-Off Ver
    Excel 1997!&2003 & 2007&2010
    Posts
    13,744

    Re: Show today's date if specified cell is modified

    ..It's OK!

    As you can understand, when you offer a solution to someone, you want to know if this worked for him(her)!

    So pls, next time let the people that tried to help you, to know, if their solution worked for you...

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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