Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#2
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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 |
#3
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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" 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Anyone have troubles running 2003 macros in 2000 version of Excel | Excel Discussion (Misc queries) | |||
Running Macros when on the LAN | Excel Discussion (Misc queries) | |||
Problem with running Macros | Excel Discussion (Misc queries) | |||
HELP - Running Macros in VBA | New Users to Excel | |||
Running Macros in protected workbook | Excel Worksheet Functions |