In the Worksheet_Change event for that sheet check if the changed cell is the
one where the date is entered

Private Sub Worksheet_Change(ByVal Target As Range)

If Target.Address(False, False) = "A1" Then MsgBox "Update Audit Signoff book"

End Sub

(Replace "A1" with the necessary address)


"Carrguy" wrote:

I want to add a prompt when i change a date in a cell. I am using a date
field that is linked to several work sheets. When i change the date i want to
be prompted with a message " update Audit sign off book" If you guy s can
help me out that would be great. Thank you in advance