Easy Trigger Question

[jasgot]

This works great when I click in the cell and change the value:

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Target.Address = Range("VB_Trigger").Address Then


How can I trigger this code if "VB_Trigger" is a self change formula from other cells?

ie; VB_Trigger is =D10+D11 so it changes on it's own and my trigger doesn't get tripped.....

 

[gnaga]

You can declare a global variable and store the content of VB_Trigger while opening the workbook. Then every cell change compare with the old content. if there is a change in the content then execute your code. finally store the current content of VB_Trigger

GNaga