I want to dynamically update some information in a excel spreadsheet but I cannot seem to find a suitable event to trigger my code.
When I enter data into a cell and then change selection, I want to run some code that picks up the data in the cell I just typed into.
Playing around, I have tried the 'SheetSelectionChanged' event but the 'Target' object refers to the cell I am now on and not the cell I had just typed into.
The 'SheetCalculate' event only triggers when there is a formula being updated to that is no good either.
Can someone point me in the right direction please?
Thanks
When I enter data into a cell and then change selection, I want to run some code that picks up the data in the cell I just typed into.
Playing around, I have tried the 'SheetSelectionChanged' event but the 'Target' object refers to the cell I am now on and not the cell I had just typed into.
The 'SheetCalculate' event only triggers when there is a formula being updated to that is no good either.
Can someone point me in the right direction please?
Thanks