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
thankyou