Lewis Walters
New Member
- Joined
- Jul 8, 2021
- Messages
- 2
- Office Version
- 2016
- Platform
- Windows
Hi all,
So I'm going to be honest. I know very little about writing VBA.
I'm working on a sheet with 2 tabs.
On the first tab I want to be able to fill out a table with Y's and N's which defines which information shows in Tab 2.
With a bit of Googling I've written a Macro to do this, however I want it to automatically execute and that's where the trouble comes.
Ideally I'd like for the Macro to run when I click on Tab 2 ONLY if something in Tab 1 has changed.
I understand I can use the Worksheet.Change Event to run the Macro but this is irritating as every time I change anything in the summary list from Y to N then it updates.
I also understand that instead I can use the Worksheet.Activate Event to run the macro every time I click on Tab 2, but this gets annoying if I'm flicking between tabs but haven't updated anything on Tab 1.
How would I go about combing the two? Or am I barking up the wrong tree and approaching this in the wrong way?
Thanks,
Lew
So I'm going to be honest. I know very little about writing VBA.
I'm working on a sheet with 2 tabs.
On the first tab I want to be able to fill out a table with Y's and N's which defines which information shows in Tab 2.
With a bit of Googling I've written a Macro to do this, however I want it to automatically execute and that's where the trouble comes.
Ideally I'd like for the Macro to run when I click on Tab 2 ONLY if something in Tab 1 has changed.
I understand I can use the Worksheet.Change Event to run the Macro but this is irritating as every time I change anything in the summary list from Y to N then it updates.
I also understand that instead I can use the Worksheet.Activate Event to run the macro every time I click on Tab 2, but this gets annoying if I'm flicking between tabs but haven't updated anything on Tab 1.
How would I go about combing the two? Or am I barking up the wrong tree and approaching this in the wrong way?
Thanks,
Lew