Thanks for the help. I have got it working on the change cell event handler, brilliant.
However the table still shows the little blue arrow for a pending change as shown here:
How can I stop this behaviour?
Also when I press enter to change the value of the cell, the selected row moves 1 down to the next row. Can I stop this from happening as I have data elsewhere that is based on the row cell that I am originally changing. Hope that makes sense!