running macros from IF

Please help, What is the command to run a macro from an IF condition. The
macro is called MacroB so: IF(K39=60,run macro,stop) from the programming
format of: if cell K39 =60 the run the macro else stop. Thank you

You can't do it that way; the True and False branches of the IF have to evaluate to a value via formulas.
Look at event procedures instead. Here's a link:

http://www.cpearson.com/excel/events.htm

--
Kind regards,

Niek Otten


"CJ" <CJ@discussions.microsoft.com> wrote in message news:F6AB3DF9-5CB0-4223-A78B-789F2C8C141D@microsoft.com...
| Please help, What is the command to run a macro from an IF condition. The
| macro is called MacroB so: IF(K39=60,run macro,stop) from the programming
| format of: if cell K39 =60 the run the macro else stop. Thank you

Thank you

"Niek Otten" wrote:

> You can't do it that way; the True and False branches of the IF have to evaluate to a value via formulas.
> Look at event procedures instead. Here's a link:
>
> http://www.cpearson.com/excel/events.htm
>
> --
> Kind regards,
>
> Niek Otten
>
>
> "CJ" <CJ@discussions.microsoft.com> wrote in message news:F6AB3DF9-5CB0-4223-A78B-789F2C8C141D@microsoft.com...
> | Please help, What is the command to run a macro from an IF condition. The
> | macro is called MacroB so: IF(K39=60,run macro,stop) from the programming
> | format of: if cell K39 =60 the run the macro else stop. Thank you
>
>
>