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.
Powered by vBulletin® Version 4.2.5 Copyright © 2024 vBulletin Solutions Inc. All rights reserved.