selection change

[sugi]

i am running an api with excel that updates cells with market data continuously. when the cell is updated i want it to trigger a function. worksheet_selectionchange and worksheet_calculate are not responding to this cell being updated. does anyone have a suggestion?
thankyou

 

[Andrew Poulsom]

This may help you:

http://www.bmsltd.co.uk/DLCount/DLCount.asp?file=LastChng.zip