one problem in excel
 

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

one problem in excel
 

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)

one problem in excel
 

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



-----Original Message-----
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
.

one problem in excel
 

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)

.

one problem in excel
 

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


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



-----Original Message-----
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
.

.

one problem in excel
 

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)

.

one problem in excel
 

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)

.