Worksheet_Change fires when the contents of a cell or cells on the
worksheet are changed by the user or via an external link.
Worksheet_SelectionChange fires when the user selects a cell or cells on
the worksheet.
So if the user selects cell J10, the Worksheet_SelectionChange event
fires. If the user then enters "hello" into the cell, the
Worksheet_Change event fires. If the user's preferences are set to move
the selection after typing Enter (or if the mouse, tab key, arrow keys,
etc. were used to leave Edit mode), the Worksheet_SelectionChange event
will also fire.
No, it is "fired" with a change on the sheet. Click on a cell and enter
something and that is a "change". Also, if you hit F2 and then Enter will
fire the change event even though there was no change to the cell.
Selection change will "fire" every time you select a cell.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
