Can a Cell Formula run a Macro

[cjcobra]

Basically, if a cell in my worksheet equals "1", run Macro X. Is there a formula I can put into the worksheet (i.e. =if(B47=1,application.run "macro",0) which of course doesn't work!, or do I have to use some code in the macro that watches the value of the cell?

Thanks!

 

[AJ]

I don't think so, but the second option you suggest is possible and there are several versions of that on the message board e.g.

http://www.mrexcel.com/board/viewtopic.php?topic=4474&forum=2

 

[cjcobra]

Thanks!

That works & got me to the next step!