text box

[badgers]

is there a way to suppress the system tone that you get when someone hits enter in a text box? The user enters info in this text box. when they hit enter I run some code. This all works but the users are asking me why their computer is making a tone
thank you for your time and have a good day

------------------
I am so skeptacle, I can hardly believe it!

[jpark]

Insert KeyAscii = 0 when Enter Key is detected.

If KeyAscii = 13 Then
KeyAscii = 0
SendKeys "{TAB}"
End If

Joon

[badgers]

thank you very much. Why the send
SendKeys "{TAB}"?
it works without it

[jpark]

Sorry, that was just my code for moving focus to next control.

Should be this

If KeyAscii = 13 Then
KeyAscii = 0
' Run ur Code here
End If

Joon