Thread: New to Events
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
David McRitchie David McRitchie is offline
external usenet poster
 
Posts: 903
Default New to Events

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,