Right click on sheet tab, view code. Paste this in, and adjust range callouts
as preferred:

Private Sub Worksheet_Change(ByVal Target As Range)

'First cell
If Target = Range("D10") Then
Range("D13").Value = Now
End If

'Second cell
If Target = Range("D11") Then
Range("D14").Value = Now
End If

End Sub

--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Geoff" wrote:

That's basically what I want to know.

There are two cells, say d10 and d11, and I would like to know exactly when
they are changed. So I'd like to have a couple cells directly below them that
have the now() result entered into it if the cell above it is changed and to
have it updated each time those cells are changed.

I can do this easily in Access with an OnUpdate routine, but I am a complete
moron WRT coding in Excel. Any help is greatly appreciated.

Anyhoo...I've finally made the leap to Office '07 kicking and screaming.
After two weeks, I can't believe I waited so long. Pretty slick stuff.
Getting used to the interfaces was a challenge, but well worth it.

TIA...geoff