For all practical purposes, macros don't run when you are in edit mode -
which is what you describe.

--
Regards,
Tom Ogilvy

"Amod" wrote in message
...
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)

.