Setting the focus to a specific cell in a datagrid

[bigmelon]

I have the following code for the current cell changed event of my datagrid:

If grdGases.CurrentCell.ColumnNumber = 10 Then
If ((Val(grdGases.Item(grdGases.CurrentRowIndex, 9)) < 6 Or Val(grdGases.Item(grdGases.CurrentRowIndex, 9)) > 8)) Then
MsgBox("Value Must Be Between 6 And 8")

End If
End If

This displays the message box if the user enters an inappropriate value in column 9, but I need to set the focus back there as well. Does anyone have any ideas on how to do this?

Thanks in advance,
Jeremy

 

[Korach]

You need to do it in the Validating event and set e.Cancel.True if you want to cancel the update.
Look in:

http://msdn.microsoft.com/library/d...emwindowsformscontrolclassvalidatingtopic.asp

 

[Korach]

Sorry, e.Cancel = True

 

[bigmelon]

How do I make that event fire while moving through the datagrid? Right now I can't get the event to fire.

Thanks,
Jeremy

 

[Korach]

I'm not so experienced with MS data grid, but I think that if you cahnge a cell value and move to another cell, the event should be fired. If you won't succeed, I'll try it myself.

 

[Korach]

I'm not so experienced with MS data grid, but I think that if you cahnge a cell value and move to another cell, the event should be fired. If you won't succeed, I'll try it myself.

 

[bigmelon]

No I put in breakpoints and in didn't do anything. The event never fired.

Jeremy