Hi,

I'd like to program the Keypress event.  But the Sheet1 does not have that
event procedure.  Where can I find it?

Thank you.

Chris

Use a textbox from the controltoolbox for a event like that

--
Regards Ron de Bruin
(Win XP Pro SP-1  XL2002 SP-2)
www.rondebruin.nl

Excel cells don't have events like this. Once you start writing into a cell then everything in Excel's in "Enter" mode and nothing
happens until you leave the cell -then the "Change" event fires and Excel calculates.

You would probably not /like/ to program the keypress event, I do it all the time and it's assembly line work fun as any. If you
tell us what you want the code to do then perhaps alternative approaches may appear.

--
HTH. Best wishes Harald
Excel MVP

Followup to newsgroup only please.