VBA Userform Code to use enter/carriage return to trigger code

[flyingmonkeyofdoom]

I wonder if any one can help wi the below code.

What should happen is that via a userform a barcode is scanned and entered into a textbox.
The scanner is set up to move to the next cell down (Return); which i am hoping to use as a trigger to do the below and start running some other code.

Current as soon as anything (letters, numbers etc) is entered the code starts and doesn't let the information be entered.
I need it to enter the information and when, and only, the infomration and ENTER/carriage return is used to implement the code below

Private Sub TextBox1_Change()    
If TextBox1.EnterKeyBehavior = True Then
        Range("F1") = UserForm3.TextBox1.Value
        Call Pivot_test
    End If
End Sub

 

[Haluk]

See the below code if it helps you;

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    If KeyCode = 13 Then
        MsgBox "You pressed ENTER key"
        '.......
        'You can place your code here
        '.......
    End If
End Sub

 

[flyingmonkeyofdoom]

when i scan the first letter being entered starts the code and doesn't wait for it all to be entered

Is there anyway of doing this?
The scanner should scan in a 11 digit alphanumeric string and then move to the line below

is the above the best code to use or should i be looking at using something else?