Show how to make a text box not beep but do something else when I hit the Enter key. This code example makes nothing happen, for an extended period of time:
Original Author: VB FAQ
Code
Sub Text1_KeyPress (KeyAscii As Integer)
If KeyAscii = 13 Then '13 is Key_Return
KeyAscii = 0
End If
End Sub