Excel VBA Table Auto Trigger Macro based on row added

[Vigash]

Hi Team,

I have connected my table to MySQL Database. If any data is updated in the database I will get it in an excel table.

If any data is added newly I want to trigger a macro. How it's possible? I tried the worksheet Change event but did not trigger the macro which I stored in Module.

Any help, Highly appreciated.

Thanks in advance

 

[offthelip]

Worksheet change event is usually only triggered by a user input change, not by a database update.
A common way round this is to use the worksheet calculate event. To get this to work you need to pick a cell that will alwyas change with every update, often this is the time stamp of the update.
Then you put a simple equation in another spare cell that does a calculation using this cell. e.g. assuming there is a time stamp in cell A1
you could this equation in Z1:

=A1+1

This forces excel to do a recalculation of that cell which will trigger the worksheet calculate event

 

[Vigash]

Worksheet change event is usually only triggered by a user input change, not by a database update.
A common way round this is to use the worksheet calculate event. To get this to work you need to pick a cell that will alwyas change with every update, often this is the time stamp of the update.
Then you put a simple equation in another spare cell that does a calculation using this cell. e.g. assuming there is a time stamp in cell A1
you could this equation in Z1:

=A1+1

This forces excel to do a recalculation of that cell which will trigger the worksheet calculate event

Hi offthelip,

Thank you for your help. I did a turnaround and it worked.

Private Sub Worksheet_Change(ByVal Target As Range)

If Not Intersect(Target, Me.ListObjects("StockOut").Range.Rows.Count) Is Nothing Then

Call lastrowfinder

End If

End Sub

Whenever row count changes in the table it will trigger my macro.