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