Running Macro's from Formula

  • Thread starter Thread starter Richard
  • Start date Start date
R

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
 
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?
 
greg mansius said:
No. In order for any code to run in this situation you would need to write a
custom function.
Click to expand...
....

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.
 
Back
Top