worksheet event macros
 

what is the essential differences between
worksheets_selectionchange
and
worksheets_change

worksheet event macros
 

Hi R,

The Worksheet_Selection change event is triggered by when the selection
moves; the Worksheet_Change event is triggered by a change of value.

See Chip Pearson's comprehensive overview of event procedures at:

http://www.cpearson.com/excel/events.htm


---
Regards,
Norman



"R.VENKATARAMAN" wrote in message
...
what is the essential differences between
worksheets_selectionchange
and
worksheets_change

worksheet event macros
 

thank you . I read through Pearsons's page. It is very clear.

But still I have one semantic doubt
in the example for worksheet _change event the second line is

If Target.Address = "$A$1" Then
Application.EnableEvents = False

but if the target or (I presume it means activecell ) is A1 should not the
the whole 'macro' be fired. in that case how can enableevents be false .
does it not mean the macro will NOT be fired.
some cobweb is there is my mind. will you kind enough to clarify.
probably I am confused about the term <target . the confusiion is there
even
in composing this message.

thanks in advance


"Norman Jones" wrote in message
...
Hi R,

The Worksheet_Selection change event is triggered by when the selection
moves; the Worksheet_Change event is triggered by a change of value.

See Chip Pearson's comprehensive overview of event procedures at:

http://www.cpearson.com/excel/events.htm


---
Regards,
Norman



"R.VENKATARAMAN" wrote in message
...
what is the essential differences between
worksheets_selectionchange
and
worksheets_change