I would suggest a simple macro based upon the Worksheet_SelectionChange
event
Something like
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
If Target = "" Then Exit Sub
MsgBox Target - Range("A1")
End Sub
for a simple subtraction which you can amend for your specific formula.
--
mrice
Research Scientist with many years of spreadsheet development experience
------------------------------------------------------------------------
mrice's Profile:
http://www.excelforum.com/member.php...o&userid=10931
View this thread:
http://www.excelforum.com/showthread...hreadid=549171