Running Macro's from Formula

[Richard]

Hello,
I am trying to get a macro to run from the result of a IF
formula. Can this be done?

Many Thanks

Richard

 

[greg mansius [MSFT]]

No. In order for any code to run in this situation you would need to write a
custom function.

Can you provide some details on what you want the "macro" to do based on
your IF statement?

 

[Harlan Grove]

No. In order for any code to run in this situation you would need to write a
custom function.

....

Maybe an event handler, but VBA functions called as udfs from cell formulas
can't & won't run macros nor change anything in Excel. They could fire other
applications using Shell which could in turn take over Excel via Automation
so as to give the appearance that the function was performing the actions,
but that requires some nontrivial programming.