Updating a date filed in a table in Word

[Biking Loki]

Not sure if this is possible in Word...but is there a way to make cell, with a date, within a table, in Word automatically change to the current date if any one of a specific range of cells changes?

I know that this is more of a Word than Excel question, but with both of these programs being so integrated, I was hoping an Excel solution would work in Word.

Thanks!

 

[Biking Loki]

Is there a way to do this just in Excel? I would like to have a cell, with a date, auto update based on any cell within a specified range of cells being changed. Is this possibel?

 

[VoG]

Try this: right click the sheet tab, select View Code and paste in

Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("B2:B10")) Is Nothing Then
    Application.EnableEvents = False
    Target.Offset(, 1).Value = Now
    Application.EnableEvents = True
End If
End Sub

Change the range to suit. This will put the date and time one column to the right.