Show today's date if specified cell is modified

**xavpg** · 02-23-2012, 12:52 PM

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!

**Richard Buttrey** · 02-23-2012, 01:09 PM

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.

**Fotis1991** · 02-23-2012, 01:13 PM

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.

**xavpg** · 02-28-2012, 06:34 PM

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

**Fotis1991** · 02-28-2012, 06:42 PM

... 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??

**xavpg** · 02-28-2012, 06:50 PM

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

**AndyPS** · 02-28-2012, 06:54 PM

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)

**Fotis1991** · 02-28-2012, 07:16 PM

..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...