Don't use the KeyPress event. Use the KeyUp event.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com


"Nacho" wrote in message
...
I have desingned a Worksheet that access information on Access
mdb. I need to
complete criteria in a text box and I want to trigger the VBA
routine when I
press return key (keypress for ASCII 13) but it does not seems
to work

Here is an example of what I'm doing:

Private Sub txtibs_KeyPress(ByVal KeyAscii As
MSForms.ReturnInteger)
If KeyAscii = 13 Then
Sheets("Base").cmdfind.Click
End If
End Sub

Any ideas?

Thanks,
from Argentina,
Ignacio