To allow the Enter key to function as a Tab, enter this code in theKeyPress event of your text boxes:
Sub Text1_KeyPress (KeyAscii As Integer) If KeyAscii = 13 Then 'Enter SendKeys "{Tab}" KeyAscii = 0 End If End Sub
This allows the user to press Enter to move from one text box tothe next. This technique will not work if you have a command button onthe form whose default property is True. The button will respond to theEnter key before the text box sees it.