From the Excel help and typing in ASCII in Excel 2003 you'll find the ASCII
character set at
office.microsoft.com/.../HA011331361033.aspx
33.


Yes VBA has a keypress event  but I believe it only applies to controls that
are placed on a sheet or a userform.

I do not believe it's possible to capture keypress  events for a
worksheet.Here is a _Change event for the worksheet and maybe that's useful
for you.

Should read...
There is a _Change event  for the worksheet

Rather than...
Here is a _Change event for the worksheet

Sorry, I forgot to mention: I need to use KeyPress on a Form... I need to close
the Form when I press ESC and to Activate a Routine when I hit ENTER.

make some property changes

ok button ( in the property window )

default = true

and the Cancel button (in the property window)
cancel = true

that will solve your prob

What I need to do is to activate a Routine when the user  press Enter (or another
key), not activate the "ok" button routine.

I think you need to read the help in VBA on the KeyDown and KeyUp events.
These catch Enter provided the OK button on the form is not set as default.
Keypress does not.

This will catch every KeyUp. You will then need to test to see if it is the
Enter key. It could make your form run slowly.