View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Niek Otten
 
Posts: n/a
Default running macros from IF

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" 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