'textbox event with key control+v shortcut from excel cell to textbox is not perfect result in vb.net
for how to event textbox with shortcut key control + v from cell excel to textbox is not perfect the result and the result is in screenhot below and how to event copy from cell excel after I paste in textbox then directly binding source filter without using "enter" while for the process I type then keep the event process using "enter".
thanks jack
Dim source1 As New BindingSource()
Private Sub TextBox1_KeyDown(ByVal sender As Object, ByVal e As System.Windows.Forms.KeyEventArgs) Handles TextBox1.KeyDown
If e.KeyCode = Keys.Back Then
source1.Filter = ""
TextBox1.Clear()
Else
If e.KeyCode = Keys.Enter Then
source1.Filter = "CODE = '" & Replace(TextBox2.Text, "'", "") & "'"
If source1.Count <= 0 Then
source1.Filter = ""
TextBox2.Clear()
MsgBox("No Result Found!", MsgBoxStyle.Exclamation)
End If
End If
End If
If e.Control = True AndAlso e.KeyCode = Keys.V Then
e.Handled = True
Dim st As String = Clipboard.GetText()
TextBox2.Text = st
End If
End Sub
Sources
This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.
Source: Stack Overflow
| Solution | Source |
|---|


