| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro - Auto - Sheet Name change ? expiry | Excel Discussion (Misc queries) | |||
| auto change font color in formula/cell | Excel Worksheet Functions | |||
| Autorun a macro on change of cell value (having formula) | Excel Worksheet Functions | |||
| is there a formula to auto change cell colours | Excel Discussion (Misc queries) | |||
| Auto Change Formula in different sheets | Excel Programming | |||
![Alex Martins[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
