Hi Jim,
Sorry it was a mistake looks like some macro recording material got mixed in.
the corrected paragraph now reads:
A Worksheet_Change event: triggers when you change a cell (or range of
cells) value manually or in a macro -- it will not be triggered from a change showing
up in a formula or from a change of format. Your change macro might be used to
automatically provide a date to another cell, , see autodate. [link].
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm
"Jim May" wrote in message news:56h_f.7930$s%6.5221@dukeread02...
By far the most recommended Reference for folks who write in an
"need-to-know" more about events is
http://www.mvps.org/dmcritchie/excel/event.htm
I'm a bit confused as in the first 1-2 minutes it reads, as regards the
Worksheet_Change event :
Will not recognize entry of a date with a short-cut (Ctrl+;), nor will it
recognize a change by pasting a value.
These 2 statements are completely false.. I'm sorry,
it's a bit like saying "the emperor has no clothes" type of thing, and I
mean no disrespect. But I for one am confused...
Can someone straighten me out?
TIA,