New to Events

  • Thread starter Thread starter Jim May
  • Start date Start date
J

Jim May

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,
 
These 2 statements are completely false..

You are correct. The Change event does indeed trigger for pasted
values (if the data was cut, no copied, Change fires twice on
Paste, once for removing the original data and again for pasting
in the new location). And it does indeed change with keyboard
shortcuts.

The Change event does not fire if the cell changes value as a
result of a calculation or a real-time data feed.

For more on events, see www.cpearson.com/excel/events.htm.

--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
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].
 
Back
Top