Misunderstood your question.

I don't know of any method to edit keystrokes within a cell.

Amod wrote:
hi
Jerry
Thanks for reply.
I was already using this event procedure. The problem with
this is Worksheet_Change will get called when you come out
of that particular cell. I want it to get called while I
am typing in a cell.
regards
Amod


-----Original Message-----
Amod wrote:

hi
all
As you all know there is an onchange event to a text

box

in VB. I want same functionality for excel worksheet

cell

or range.
If you have any idea please let me know.
thanks in advance.

regards
amod

Private Sub Worksheet_Change(ByVal Target As Range)

.