Have you tried the help available in the VBA debugger? The help in earlier versions of Excel is FAR superior to the help in Excel2007 (in my opinion) but it's still.... "helpful"..
If you search for "Change Event" you'll find entries for both of the events. To summarize: Worksheet.Change Event Occurs when cells on the worksheet are changed by the user or by an external link. Worksheet.SelectionChange Event Occurs when the selection changes on a worksheet. That means that the SelectionChange is exactly that. When you change the cell SELECTED on a sheet. (You currently have cell A1 selected, then you click in Cell B1, or hit the "down" arrow) the event is triggered and the new cell (and the Target range is passed to the function) the worksheet_change event is triggered when something is actually CHANGED. But that in itself can be tricky. If you have a formula such as =now() (shows the current date and time) and you recalculate the sheet. Of course the time has changed, so the sheet LOOKS different, but according to Excel, the "value" of the cell, (the function =now()) has NOT changed, so therefore no event is triggered. This can get frustrating when your formula is pulling data from another sheet (or workbook) and that value changes, causing changes to the current sheet, but the event doesn't run because the "formula" itself didn't change... If you ever run into a problem like this, you may have to also look into utilizing the Worksheet_Calculate event. hth, paul ----- Original Message ---- > From: capt edgar <capted...@googlemail.com> > To: MS EXCEL AND VBA MACROS <excel-macros@googlegroups.com> > Sent: Wed, January 6, 2010 1:54:01 AM > Subject: $$Excel-Macros$$ Event Difference > > Hi there > > Can u please tell me what is the difference between worksheet_change > and worksheetselection_change events please? > > I can't find a proper definition for it on google anywhere. > > Also can u tell me a good place for code snippets for vba for quick > use in vba programming > > regards > -- > ---------------------------------------------------------------------------------- > Some important links for excel users: > 1. Follow us in TWITTER for tips tricks and links : > http://twitter.com/exceldailytip > 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at > http://www.excelitems.com > 3. Excel tutorials at http://www.excel-macros.blogspot.com > 4. Learn VBA Macros at http://www.quickvba.blogspot.com > 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com > > > To post to this group, send email to excel-macros@googlegroups.com > If you find any spam message in the group, please send an email to: > Ayush Jain @ jainayus...@gmail.com > <><><><><><><><><><><><><><><><><><><><><><> > HELP US GROW !! > > We reach over 6,500 subscribers worldwide and receive many nice notes about > the > learning and support from the group.Let friends and co-workers know they can > subscribe to group at http://groups.google.com/group/excel-macros/subscribe
-- ---------------------------------------------------------------------------------- Some important links for excel users: 1. Follow us in TWITTER for tips tricks and links : http://twitter.com/exceldailytip 2. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 3. Excel tutorials at http://www.excel-macros.blogspot.com 4. Learn VBA Macros at http://www.quickvba.blogspot.com 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com <><><><><><><><><><><><><><><><><><><><><><> HELP US GROW !! We reach over 6,500 subscribers worldwide and receive many nice notes about the learning and support from the group.Let friends and co-workers know they can subscribe to group at http://groups.google.com/group/excel-macros/subscribe
