When you hit enter key in a text(if its multiline property is false), it beeps and do nothing. You can mask that beep and move the focus to other control.

In KeyPress event of the text box write the following code:

If KeyAscii = 13 Then '13 is Key_Return
    KeyAscii = 0
    Sendkeys "{tab}"
End If