PDA

View Full Version : Solved: Change Event not triggering with "Tab" key



craigers77
12-29-2010, 03:36 PM
I finally have my worksheet change event doing what I want, but it will not trigger if I am moving thru the cells using the "tab" key (only enter). Can someone shed some light on this?

Thanks.

mbarron
12-29-2010, 04:16 PM
You have to use a Worksheet_SelectionChange event, not a Worksheet_Change event.

Worksheet_Change are triggered when the contents of a cell are changed.
A Worksheet_SelectionChange is triggered when a different cell is selected.

craigers77
12-30-2010, 09:59 AM
Thanks. I couldn't get the Worksheet_SelectionChange event to work originally, but once I learned how to "restrain" my destination range it worked wonderfully.