run code when enter is pressed in userform.

[depcdivr]

Is there a way that will run the code from a button when the enter key is pressed. Currently the enter key moves to the next text box in the user form.

 

[ChrisM]

Use the textbox's keydown procedure:

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)

    If KeyCode = vbKeyReturn Then
        CommandButton1_Click
    End If

End Sub

 

[depcdivr]

Thanks worked like a charm.