Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ
 
Posts: n/a
Default 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
  #2   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


  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
CJ
 
Posts: n/a
Default running macros from IF

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Anyone have troubles running 2003 macros in 2000 version of Excel Jim Excel Discussion (Misc queries) 0 April 19th 06 02:15 PM
Running Macros when on the LAN Bettergains Excel Discussion (Misc queries) 0 October 6th 05 09:38 PM
Problem with running Macros Mark Alex Excel Discussion (Misc queries) 1 May 17th 05 02:28 PM
HELP - Running Macros in VBA Louise New Users to Excel 7 April 6th 05 03:21 PM
Running Macros in protected workbook petunia Excel Worksheet Functions 3 January 18th 05 09:24 PM


All times are GMT +1. The time now is 05:32 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"