Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
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,




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
events? [email protected] Excel Discussion (Misc queries) 1 September 14th 05 03:26 PM
Events ojv[_2_] Excel Programming 3 October 22nd 04 01:59 PM
events jacob Excel Programming 2 September 7th 04 02:15 PM
Need some events... Tim Mattingly Excel Programming 0 August 16th 04 09:53 AM
events Mark[_17_] Excel Programming 1 October 31st 03 09:18 AM


All times are GMT +1. The time now is 09:39 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"