ipbr21054
Well-known Member
- Joined
- Nov 16, 2010
- Messages
- 5,226
- Office Version
- 2007
- Platform
- Windows
Evening.
I have this code but not sure if its correct for me.
What im trying to do is enter values into my userform then when i press the enter button the values are sent from userform to worksheet.
The above works but i need to press enter twice,this is why maybe its incorrect for me or i did something wrong
Thanks
I have this code but not sure if its correct for me.
Rich (BB code):
Private Sub UserForm_Click()
If KeyCode = vbKeyReturn Then
Call CommandButton1
End Sub
What im trying to do is enter values into my userform then when i press the enter button the values are sent from userform to worksheet.
The above works but i need to press enter twice,this is why maybe its incorrect for me or i did something wrong
Thanks