Is it possible to run a macro from within a formula?

eg =If(A1="yes", run macro, " ")

I hope it is! please help me here

Thanks