Now, if there is a second user entered value in B1 how would I amend the
formula to give the reminder if either value is changed. Also, is it possible
to prevent the msgbox alert when the initial value is entered? Les.


"LesLdh" wrote:

Thanks Otto, just what I was looking for. Les.

"Otto Moehrbach" wrote:

How about a message box? Paste the following macro into the sheet module
for that sheet. You do this by right-clicking on the sheet tab, select View
Code, and paste this macro into the displayed module. HTH Otto
Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Count 1 Then Exit Sub
If Target.Address(0, 0) = "A1" Then _
MsgBox "Don't forget to do this and that also."
End Sub
"LesLdh" wrote in message
...
I have a user entered value in cell A1. What I want to do is have a
reminder
to update other cells flash up in cell A2 when the value in A1 is changed

Any ideas?