Hi i have a problem whit the KeyDown function in VBA Code.
I´m going to use 2 textboxes to collect data from a scanner frist scan should fill the first textbox and the second scan should fill the second textbox and add the data in to the Excel sheet.
Problem is that i can get the code to work.
TextBox2_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = vbKeyReturn Then
End If
End Sub
I need the UserForm to clear the data after entring data to the worksheet and set focus to thexbox 1 again .
Any ides ?
I´m going to use 2 textboxes to collect data from a scanner frist scan should fill the first textbox and the second scan should fill the second textbox and add the data in to the Excel sheet.
Problem is that i can get the code to work.
TextBox2_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
If KeyCode = vbKeyReturn Then
End If
End Sub
I need the UserForm to clear the data after entring data to the worksheet and set focus to thexbox 1 again .
Any ides ?
