How to use VBA's Worksheet.TableUpdate event RRS feed

  • Question

  • Trying to use the Worksheet.TableUpdate event in VBA with the following syntax...

    "Private Sub Worksheet_TableUpdate(ByVal Target As TableObject)"

    but the sub is not triggered when I refresh the only PowerQuery query in the document. The code is on the Sheet1 module as there's only 1 sheet in the workbook. 

    What's the correct syntax for this event? And could you provide a working example (i.e. one that you've tested)?

    Tuesday, September 20, 2016 7:16 PM


All replies