Temp Wrote:
A little more generic:

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Worksheet.Range("A1") = Target.Worksheet.Range("B1") Then
MsgBox "Example"
'' or put a macro name here
End If
End Sub

I found this thread by using search, thanks.

So I make the above a new macro and run it first every time I start the
xls file? or?


--
MikeZ
------------------------------------------------------------------------
MikeZ's Profile: http://www.excelforum.com/member.php...o&userid=27383
View this thread: http://www.excelforum.com/showthread...hreadid=447059