Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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, |