one problem in excel

[Amod]

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

 

[Jerry Park]

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)

 

[Serkan]

Private Sub Worksheet_SelectionChange(ByVal Target As
Range)
If Target.Address = "$A$1" Then
..
..
..

 

[Amod]

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

 

[Amod]

Hi
Serkan
Thanks for reply.
As you suggest I have used Worksheet_SelectionChange event
procedure, but this procedure gets called when u type in a
particular cell suppose A1, then you left that cell and
type in other or just traversed through other cells, after
that when you again go to A1 cell then this event get fire.
so this event is not useful for me.
I want an event procedure which get fired while I am
typing in the A1 Cell.

regards
Amod

 

[Jerry Park]

Misunderstood your question.

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

 

[Tom Ogilvy]

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