'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

viewexcel resultintextbox



Sources

This article follows the attribution requirements of Stack Overflow and is licensed under CC BY-SA 3.0.

Source: Stack Overflow

Solution Source