We have CellBeginEdit and CellEndEdit. Could we have a CellCancelEdit event as well?
When user editing value in a cell, usually the validation process usually taken in the CellValidating event. In the CellValidating event, I display validation error messages on the status bar and with a beep. When the user pressed the Escape key to cancel the edit mode, I would like to clear out any validation error on the status bar. Right now, there is no easy way to detect when the user cancel the edit mode.
One solution would be keytrapped the grid and detect when the ESC key is pressed together with a boolean variable to keep track of when user entered edit mode. But this is ugly and not elegant at all :)
Phi
When user editing value in a cell, usually the validation process usually taken in the CellValidating event. In the CellValidating event, I display validation error messages on the status bar and with a beep. When the user pressed the Escape key to cancel the edit mode, I would like to clear out any validation error on the status bar. Right now, there is no easy way to detect when the user cancel the edit mode.
One solution would be keytrapped the grid and detect when the ESC key is pressed together with a boolean variable to keep track of when user entered edit mode. But this is ugly and not elegant at all :)
Phi