View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
moon moon is offline
external usenet poster
 
Posts: 20
Default How do I run a macro from inside an"=IF" formula in Excel 2003?


"Drawn83" schreef in bericht
...
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.


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.