Cellvalidating event order
Another of your questions is concerned with trying to get the Error Text to show, but you are using the Cell Validating event in that.
The more normal approach is to use Error Text with a Row Validating event.
And certainly, if we are to help you to change the "out of the box" provisions, we need to know what the strategy is.
Is validation to be done at cell level or at row level?
And we (or at least I) cannot discern that from any of your questions. As long as I can get rowvalidate to happen I will be able to solve the rest.
I try to set the current cell to the cell that I am on in rowvalidation, but this does not work.Rather than answering any of them directly, at least at this point, can I suggest that you step back from the detailed issues for a moment or two, and decide on a very specific Validation strategy and then describe it here and then we will probably find it easier to help you.The problem is that although there are a variety of Data Gridview methods concerned, in one way or another, with "validation" they are not always designed to be used together or interchangeably.Make a form with a datagridview with the rowvalidating event setting e.cancel=true (throw in a message box if you want, it doesn't matter), this should never allow you to leave the grid. Click Msg Box("button pressed") End Sub Private Sub Data Grid View1_Row Validating If loading Then Exit Sub Msg Box("row validate") e.Put a button on the form with a click event that has a message box that says "button pressed". Cancel = True End Sub End Class The first bits are just to provide data to work on.