When hitting "Enter" on a text box, how do I make it execute a command

[mark01]

I have a text box, with an OK, and a Cancel Button. I want it to execute the OK when I hit enter after typing in text on the text box. How would I do that?

 

[TysonLPrice]

If I understand what you are saying correctly set focus to the save cmd after the edit. You may have to play around with got focus and lost focus on the text box to do it.

 

[mark01]

This is what I have:

Private Sub Text1_LostFocus()
Call Command1_Click
End Sub

This doesn't work for me

 

[vidru]

How about setting the Default property of the 'OK' button to true?

-dave

 

[AndyTWI]

The simplest way to do this is using the KeyPress event:

Private Sub txtYourTextbox_KeyPress(KeyAscii as Integer)
    If (KeyAscii = vbKeyReturn) Then 'ENTER key is pressed
        Call cmdYourCommandButton_Click()
    End If
End Sub

 

[mark01]

Awesome, thats exactly what I needed. I am a little slow. Thanks!