EXCEL VBA FUNCTION TRIGGERING
Posted on 2011-09-08
How do you cause a custom function to execute when changes are made to worksheets / cells?
So, if I have a custom function in a cell, that uses data from multiple worksheets, I need for the custom function to run based on those changes. Obviously, it may or may not impact the value returned into the cell by the function, but I need to make sure it runs. In other words, I want it to behave like any other excel function.
My custom function is currently working, but If I change values in cells within the worksheet, it does not re-execute.
Any help on this would be greatly appreciated.