Wondered if anyone could help me on this one, after a few failed attempts and browising other similar topics found...
I have a combination of change event macro before double click event macros on a worksheet.
I any cell in either Column A or B is double clicked, the cell contents are deleted.
If another cell is then selected or enter is pressed without any new data being inputted, the previous data is re-populated into the cell (i.e. before the deletion).
However, if the user double clicks on the cell to edit the data, but then presses the ESC key rather than selecting another cell or pressing enter, the change event macro to repopulate the cell does not run.
Is there any way of preventing the user from being able to "escape" out of editing a cell, and limiting it to a specific range?
Failing that, is there any way to run a macro if a user presses escape, whilst editing a cell? (I've tried using OnKey macros, but I can't get them to work whilst the cell contents are being edited)
Thanks
Bookmarks