View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Alex Martins[_2_] Alex Martins[_2_] is offline
external usenet poster
 
Posts: 29
Default Change in cell from formula to auto run a macro

Hi, I have been struggling with a problem for some time now, and I can't fin
my way around it.

I have a cell f2 that has a formula, and I want Macro1 to run automatically
when that value is different than 0, or Macro2 to run if that value is = 0.
The thing is it detects manual changes (like tyoing the number myself), but
it does nothing when the value changes using the formula.

Any ideas, suggestions, etc.?

Many thanks in advance.
Alex