Is there an excel add-in or vba code to track change events in any active workbook or active worksheet ?

[fourdragons]

Hi,
I was just creating a function to display the color index of the selected cell, the code works fine. The problem is that whenever the referred cell's color is changed, the function doesn't update itself automatically, we would have to set focus on the cell with the formula to get it updated . Is there any solution to this?

I was thinking of an add-in that can easily track the change event of any active worksheet which may in-turn be used to update this function automatically.
Please let me know if there is an add-in or any other way to solve this?

Function color_index(ByRef rng As range)
     color_index = rng.Interior.ColorIndex
End Function

Thanks in advance

 

[Fluff]

There is no way to detect that the format of a cell has changed. One workaround would be to have a selection change event that re-calculates the sheet, but if you change the format nothing will happen until you select a different cell.