It is VBA code and all VBA code is a part of the file in which it resides.
HTH Otto
"crash20001" wrote in message
...
I am having issues with the event marco location. Is it in the VB code or
in
Excel?

"Harald Staff" wrote:

Formulas can not run macros, it's a limitation by design. You might
instead
have a look at the worksheet_change event macros in the sheet module or
thisworkbook module, they run on cell entries.

HTH. Best wishes Harald

"crash20001" wrote in message
...
I would like to know if it possible to run a marco inside a formula. I
am
looking to put a formula together that uses a "If" statement, that if
true
it
would run a marco?

Thanks