How do I run a macro from inside an"=IF" formula in Excel 2003?

D

Drawn83

I need to run a short macro from inside an Excel "IF" formula; running one
macro when the "IF" statement is TRUE, and another macro when the "IF"
statement is FALSE.
 
M

moon

Drawn83 said:
I need to run a short macro from inside an Excel "IF" formula; running one
macro when the "IF" statement is TRUE, and another macro when the "IF"
statement is FALSE.
Click to expand...

You can do that, but not from a 'normal' IF-formula. First create your own
user defined function, like =OWNIF(), and then call a macro from there.
 
Top