Trigger cellvalidating event
I want to add a new rows when cell leave event occurs.
Now, since so many books use the Cell Validating event, I wonder if there is not any gotcha (in display for example) with using the Cell Value Changed?
EDIT The biggest thing about the Cell Validating event is that you can stop the user from leaving a cell, if the value entered does not pass your validation.
Further, let’s say that you’d like to know as soon as the user has made a change to their selection.
You might want to handle this for a number of reasons: to enable a save button, to change the appearance of selected items, to display a pop-up window, or to check for consistency against other choices.
It turns out that this is trickier than it might seem and doesn’t work great out of the box from .