We value your feedback.
Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!
Course Of The Month
10 days, 9 hours left to enrollBecome a Premium Member and unlock a new, free course in leading technologies each month.
Solved
VB.Net Datagridview - Return to edited cell
Posted on 2014-02-05
Hi Experts. On CeIlEndEdit I am trying to check the number of digits in the cell and if incorrect get the focus back to the cell so that the next key pressed appears in the cell to be corrected. It works sometimes but most times the next key pressed appears in the cell that was selected after leaving the first cell. Any help would be appreciated.
Relevantcell = DataGridView2.CurrentCell
If DataGridView2.CurrentCell.
If Relevantcell.FormattedValu
MsgBox("The number is too short")
DataGridView2.CurrentCell = Relevantcell
DataGridView2.BeginEdit(Tr
Exit Sub
End If
End If
Relevantcell = DataGridView2.CurrentCell
If DataGridView2.CurrentCell.
If Relevantcell.FormattedValu
MsgBox("The number is too short")
DataGridView2.CurrentCell = Relevantcell
DataGridView2.BeginEdit(Tr
Exit Sub
End If
End If
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
2
4 Comments
Active 3 days ago
Have you tried using CellValidating event instead?
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.cellvalidating(v=vs.110).aspx
http://msdn.microsoft.com/en-us/library/system.windows.forms.datagridview.cellvalidating(v=vs.110).aspx
Active 2 days ago
why are you using 'CurrentCell'?
Private Sub DataGridView1_CellEndEdit(ByVal sender As Object, ByVal e As System.Windows.Forms.DataGridViewCellEventArgs) Handles DataGridView1.CellEndEdit
Dim relevantcell = CType(sender, DataGridView).Rows(e.RowIndex).Cells(e.ColumnIndex)
End Sub
Active today
Thanks for the reply. I changed the code to the following. The messagebox appears, then the focus moves to the correct cell ready for editing but the next key stroke then appears in the cell that was clicked after the incorrect data was added. Also, if I manually return to the cell, the error checking does not work twice. Thanks again for the reply
Dim Relevantcell As DataGridViewCell
Relevantcell = CType(sender, DataGridView).Rows(e.RowIn
If DataGridView2.CurrentCell.
If Relevantcell.FormattedValu
MsgBox("The number is too short")
DataGridView2.CurrentCell = Relevantcell
DataGridView2.BeginEdit(Tr
Exit Sub
End If
End If
Dim Relevantcell As DataGridViewCell
Relevantcell = CType(sender, DataGridView).Rows(e.RowIn
If DataGridView2.CurrentCell.
If Relevantcell.FormattedValu
MsgBox("The number is too short")
DataGridView2.CurrentCell = Relevantcell
DataGridView2.BeginEdit(Tr
Exit Sub
End If
End If
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
This article explains how to create and use a custom WaterMark textbox class. The custom WaterMark textbox class allows you to set the WaterMark Background Color and WaterMark text at design time.
IMAGE OF WATERMARKS
STEPS
Create VB …
The ECB site provides FX rates for major currencies since its inception in 1999 in the form of an XML feed. The files have the following format (reducted for brevity)
(CODE)
There are three files available HERE (http://www.ecb.europa.eu/stats/exch…
In this video, viewers are given an introduction to using the Windows 10 Snipping Tool, how to quickly locate it when it's needed and also how make it always available with a single click of a mouse button, by pinning it to the Desktop Task Bar.
Int…
This is my first video review of Microsoft Bookings, I will be doing a part two with a bit more information, but wanted to get this out to you folks.
Suggested Courses
Earn Certification
HTML5 Specialist - Certification
Free withPremium
Course of the Month10 days, 9 hours left to enroll
631 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.