How to update range when active sheet is not active any more

[szchris384]

Hello, trying to update a range in another worksheet, but only when the active worksheet is not selected anymore.

Ie, 4 worksheets in my workbook, sheet1...sheet4.
When user changes something in sheet4, then selects sheet3, I would like vba code to update a range in sheet1. But this can only update the range in sheet1 when the user clicks onto any other sheet.

I have a button right now for them to click to go to sheet3, but if they don't click that button and click sheet3 directly, it won't update. That's why I require to update a range in sheet1 when they click off of sheet4.

Thanks for any help.
Chris

 

[Chris Macro]

You can add an event handler in the worksheet code of sheet3 to run code when sheet3 is activated....in the Visual Basic Editor you can add macros to the worksheet objects by double clicking the worksheet name in the project window and then use the object/procedure dropdowns (screenshot is in this post) to select the event you want to use. Then insert your code within the Event Sub