Skip to content

Instantly share code, notes, and snippets.

@davefinster
Created June 22, 2017 03:20
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save davefinster/1b1d9a69676fcfff8a0e58c1b9b07808 to your computer and use it in GitHub Desktop.
Save davefinster/1b1d9a69676fcfff8a0e58c1b9b07808 to your computer and use it in GitHub Desktop.
Private Sub Worksheet_Change(ByVal Target As Range)
Dim KeyCells As Range
Set KeyCells = Range("A2:A2")
Set OtherKeyCells = Range("C2:C2")
Set DateCells = Range("A5:B5")
If Not Application.Intersect(KeyCells, Range(Target.Address)) _
Is Nothing Then
Set wksControl = Worksheets("Org Groups")
Set objList = wksControl.ListObjects("Organisation_Groups")
objList.Refresh
End If
If Not Application.Intersect(OtherKeyCells, Range(Target.Address)) _
Is Nothing Then
Set wksControl = Worksheets("Dockets")
Set objList = wksControl.ListObjects("DocketLineItems")
objList.Refresh
End If
If Not Application.Intersect(DateCells, Range(Target.Address)) _
Is Nothing Then
Set wksControl = Worksheets("Dockets")
Set objList = wksControl.ListObjects("DocketLineItems")
objList.Refresh
End If
End Sub
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment