close

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:

www.cpearson.com/excel/events.htm

--
Kind regards,

Niek Ottenquot;CJquot; gt; wrote in message ...
| 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

quot;Niek Ottenquot; wrote:

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

arrow
arrow
    全站熱搜
    創作者介紹
    創作者 software 的頭像
    software

    software

    software 發表在 痞客邦 留言(0) 人氣()