Don't use command button in a userform

[still learning]

Hi

How do I change the following userform code to have the user press enter after a name is entered, instead of having a command botton?

Private Sub TextBox1_Change()
End Sub

Private Sub TextBox5_Change()
End Sub

Private Sub CommandButton1_Click()
With TextBox5      'last name
ActiveSheet.Range("p2").Value = .Text
End With
With TextBox1      'first name
ActiveSheet.Range("q2").Value = .Text
End With
Me.Hide
Findd       ‘ this is the macro that will find the name using “advance filter”
Unload Me
End Sub

mike

 

[EXCEL MAX]

Hello stilllearning,
use KeyDown event for each Textbox.
For example...

Private Sub TextBox5_KeyDown(ByVal KeyCode As MSForms.ReturnInteger, ByVal Shift As Integer)
    
     If KeyCode = 13 Then
        With ActiveSheet
            .Range("p2").Value = TextBox5.Text
            .Range("q2").Value = TextBox1.Text
        End With
        Me.Hide
        Findd
        Unload Me
     End If
     
End Sub

 

[still learning]

Hi EXCEL MAX
Thank you

What does KeyCode = 13 mean

mike

 

[EXCEL MAX]

Each key on keyboard have number.
13 is the number of the "Enter" key.
You can check key number with
inserting in the textbox KeyDown event "Msgbox Keycode".
For example...

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