I would like to retain editing the cell if the value enter to the cell is not a valid value. I tried doing validation in BeforeCellUpdate, and if the validation fails, it sets the e.Cancel = true, but all it does is revert the value back to the original value, but still allows me to go into another cell for edit.
You would have to access the cell using ActiveCell look at either ActiveCell.Text or ActiveCell.EditorResolved.Value depending if you need the cell resolved.
Nick
Hi,
I have the same problem as mentioned above. Using BeforeExitEditMode is not an option because the cell itself is not sent in the event arguments or am I missing something.
Maybe there is some other solution?
Stefan
It sounds like the BeforeExitEditMode would be the perfect candidate for what you are trying to do, since if you don't consider the value valid, cancelling the event will prevent the user from exiting edit mode, and thus the cell.
-Matt