Need an event when user types in a cell?

Hello,

Is there an event that can be fired by excel when only the user starts typing in a cell?

Not when the user selects a cell or when a user hits enter after he modified the cell's contents ... but merely the moment that he hits any key of any selected cell!

P.S. Worksheet_Change() and Worksheet_SelectionChange() don't work....

Thanks for your help

Originally Posted by Norie

What are you trying to do?

As soon as a user starts typing in a cell Excel enters edit mode, and code can't be run in edit mode.

Certain code under some buttons need to know that the excel cursor is placed (selectedd) in certain cells in order to allow the
code to these buttons to run properly.... so therefore I can't lock the cell since I check if it's selected or not.

Also these same cells must always contain a special character which is
invisible to the user.... so it can't be changed!!!!

So in a nutshell, As soon as the user selects the cell.... then that's fine !!! but if he starts typing in it, I need a way to abort the typing by moving
the excel cursor in another cell and assure that
the cell is not changed !

If you have any ideas, please let me know

thanks for replying!