Events in Excel for executing functions

[Robin]

Is there any special event that excel fires when a specific
calculation is completed in a CELL. For example

in Cell A5 I have =FuncLookAtAllDBRequest("SomeStringID") When this
function completes I need to know whether I can call some macro to
send me an email using VBA. Are there any events that tell
BeforeFunctionCalled(".....") or AfterFunctionCalled(".....") etc....
Is this already there is Excel or are there any VBA code sample that
will do it.

I have several functions been called within a sheet they do scientific
calculation and I need to notify the needful people when they complete
the calculations etc....

I would really appreciate if someone tells me how to do it and that I
can do it in C# or C++ if not VBA is cool too.

Thanks
Robin

CC:Events in Excel for executing functions

 

[jeff]

YOu can put something like this in the worksheet
code. (rightclick on the tab, go to view code)
The following brings up a message box when cell
A1 is changed to "X"

Private Sub Worksheet_Change(ByVal Target As Range)
Dim r As Range
Set r = Target

If r.Address = "$A$1" Then If Target = "X" Then _
MsgBox "Boo"
End Sub


hope it helps