Linking the ENTER key to a Button on a Form?

[Jason Paris]

Hi folks,

I'm creating a User Form in Excel. It includes a Text Box and a
number of buttons.

When the user types into the Text Box and (instinctively) presses
ENTER, is there a way to simulate the clicking of a button? In other
words, can ENTER - when pressed from the Text Box - be used to trigger
the code behind a button?

Many thanks,

Jason Paris

 

[tissot.emmanuel]

Hi,

Your textbox name is TextBox1, your button name is btnOK:

Private Sub TextBox1_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal
Shift As Integer)
If KeyCode = 13 Then btnOK_Click
End Sub

Private Sub btnOK_Click()
MsgBox "OK launched by ENTER"
End Sub

Regards,

Manu/