Forum Discussion
VBA code for triggering a macro based on change in cell with formula
I'm trying to get a macro to run based on a change in value in a cell, but the cell contains with a formula so the standard trigger on value does not work. Any suggestions ?
The problem is that the formula comes from a external feed, and not a sum or so from other cells
example :
=QueryJoule("Italy Baseload - All Venues", "", "1", "bid price", "1", "Quarters")
and the feed ends up to be a number
=QueryJoule("Italy Baseload - All Venues", "", "1", "bid price", "1", "Quarters")
and the feed ends up to be a number
You'll have to use the Worksheet_Calculate event.
