using enter to start a macro in from a userform instead of a command button

[still learning]

Hi

I’m using a command button in a userform to start a macro after data is entered in a text box
How do I modify or add to the code so I can use the enter key instead?

Private Sub CommandButton1_Click()
    With TextBox1 
        ActiveSheet.Range("ae3").Value = .Text
     End With
    With TextBox2 
        ActiveSheet.Range("af3").Value = .Text
     End With
    With TextBox3  
        ActiveSheet.Range("ag3").Value = .Text
     End With
    With TextBox4  
        ActiveSheet.Range("ai3").Value = .Text
     End With
    With TextBox5 
        ActiveSheet.Range("aj3").Value = .Text
     End With
   With TextBox6 
        ActiveSheet.Range("al3").Value = .Text
     End With
 Me.Hide
End With
chchkfind
Unload Me
End Sub

Chckfind runs an advance filter using what is in the text box(es)



mike

 

[Jaafar Tribak]

How about setting the Default Property of the CommandButton to TRUE

 

[still learning]

Hi Jaafar Tribak
Can you show me how?


mike

 

[Jaafar Tribak]

Hi Jaafar Tribak
Can you show me how?


mike

Select the commandbutton and change the Default Property to TRUE in the VBE Properties window.

If you want to do this at runtime, you can use this code :

Private Sub UserForm_Initialize()
    Me.CommandButton1.Default = True
End Sub

 

[still learning]

Thank you Jaafar Tribak
It worked like i wanted it to
Another learning experience

Stay safe with whats happening in the world

mike