Stopping the beep sound

[dvannoy]

how do I stop the Beep sound when using the below code..
I've tryed this a few different ways..

If KeyAscii = vbEnter Then
KeyAscii = 0
SendKeys "{tab}"
End If

only get the beep when in text boxes..

Thanks

 

[MrMoocow]

I'm not sure, but have you tried switching the order? Brad,
Hey! email me any time! Bradsvb@yahoo.com

 

[rdavis]

are you using vbEnter as the Enter key on the keyboard? if so, replace vbEnter with 13. vbEnter is a dragoverconstant that is equal to 0.

 

[rdavis]

replace vbEnter with vbKeyReturn

Rob

 

[dvannoy]

I tryed several ways.. The only way i got it to work was to place this in the key press

If KeyAscii = 13 Then
KeyAscii = 0
End If

then call my sub

now it works..

if i place the above code in my sub, it wont work for some reason..

Thanks

 

[RonVaught]

Pressing <Enter> while a textbox has focus causes the Beep / error if it’s multi line property is set to false. Change the multi line property of the text box to true. Keep in mind that your text box will now accept multiple lines of text.

 

[rdavis]

it looks like he wanted the Enter key to simulate the Tab key, he was using vbEnter instead on vbKeyReturn, correct me if I'm wrong dvannoy.

Rob

 

[vb5prgrmr]

Your right rdavis, dvannoy it should be vbKeyReturn and I seem to remember a previous thread from a month or so ago that was about the same thing. You might want to search for it (beep sound).

Good Luck