still learning
Well-known Member
- Joined
- Jan 15, 2010
- Messages
- 784
- Office Version
- 365
- Platform
- Windows
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?
mike
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?
VBA Code:
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