hello :-)

thank you all for your answers. Yes that's it exactly, it should do the same
thing as the bloomberg/reuters/telekurs formulas.

I will use your inputs and try if i can make it work and post the results
here as it may help you too sunny :-)

thank you & best wishes
-ToM-

"sunny" wrote:

I'm doing the exactly same thing......
The customer may want bloomberg-like functionality.....
I'm doing this way....
The worksheet function returns the first record and stores the other
records in the internal storage like arrays..
Then, trap the SheetChange event (or other event like SheetCalculate)
and put the rest of the results.....

I'm doing this using COM add-in with native C++... but... I can't do
the event handling part correctly...
Displaying the rest of the results is ok... but, after that, EXCEL
crash....!

Please help me.... Show me how to handle SheetChange event...