Here is the order of events that occur: The following identifies the order of validation, enter/leave and begin/end edit events. When moving from cell to cell (in the same row) 1) Cell Leave (old cell) 2) Cell Validating/ed (old cell) 3) Cell End Edit (old cell) 4) Cell Enter (new cell) 5) Cell Begin Edit (new cell) When moving from one row to another you get: 1) Cell Leave (old cell), Row leave (old row) 2) Cell Validating/ed (old cell) 3) Cell End Edit (old cell) 4) Row Validating/ed (old row) 5) Row Enter (new row) 6) Cell Enter (new cell) 7) Cell Begin Edit (new cell) I totally agree about jmcilhinney not-very-polite-at-all-answer ...I (and MANY more out there, try googling) have the same question.Based on the user selection (Yes or No), you can execute the appropriate code.The third parameter of the Show method is a Message Box Button enumeration.If you dont want to answer, or dont know where I can find the answer then dont respond.
I realize you know quite a bit, but that was a little degrading.
We can use Message Box Result to determine what button was clicked on a Message Box and take an appropriate action. Here are the code samples and their results of these 13 overloaded methods.