Macro to run when formula result changes

[scarlett3]

Hi

I have an IF formula in cell B9 then either returns "N" or "Y" as the result. I've read that a macro cannot be run based on changed in formula results, but is there a workaround to this?

I'd like the macro to run if the formula result changes from "N" to "Y".

Thanks!

 

[Joe4]

What is this formula in B9?
Do you only want it to run the first time it changes from "N" to "Y"?

 

[scarlett3]

It's a simple =IF(H6>H1,"Y","N") formula.

Yes, I suppose I would only want it to run the macro once, just in case the various cell values changed so that it alternated between "Y" and "N".

 

[lenze]

So, how are the values in H6 and H1 changed?
User Input? Data Import?, Formula? If Formula, what is it?

lenze

 

[scarlett3]

H1 is a fixed value; H6 is a value from a data import which refreshes every second.

 

[Joe4]

Sounds like you might want to use the Worksheet_Calculate Event Procedure.

Chip Pearson did a nice write-up on them a few years ago: http://www.cpearson.com/excel/Events.aspx

You can also find some good examples if you search this forum for "Worksheet_Calculate".