Created
April 15, 2021 12:43
-
-
Save cgbosse/04b6e9a80a11589edc130171133e08fa to your computer and use it in GitHub Desktop.
Excel Macro - Triggers - Cell Changes
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
Private Sub Worksheet_Change(ByVal Target As Range) | |
.................. | |
End Sub | |
Note: | |
Gets triggered when any cell on the sheet changes. | |
I used this to make it possible to update several lists generated through pivot tables that got updated each | |
time a change on the input worksheet occured. |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment