![]() |
Rum macro in procedure
Hi guys.
I have to call a macro (macro2) from wthin "Private Sub Worksheet_Activate()" How can i do this? Thanks!!! SpeeD |
Rum macro in procedure
Thanks a lot!
By the way if i want to run a macro from a "IF" formula in a cell, how can i do it?? Thanks!!!!! -----Original Message----- Private Sub Worksheet_Activate() macro2 end Sub -- HTH Richard Choate, CPA "SpeeD" wrote in message ... Hi guys. I have to call a macro (macro2) from wthin "Private Sub Worksheet_Activate()" How can i do this? Thanks!!! SpeeD . |
Rum macro in procedure
IF cell (a,b) = ... THEN
Call macro END IF "SpeeD" wrote in message ... Thanks a lot! By the way if i want to run a macro from a "IF" formula in a cell, how can i do it?? Thanks!!!!! -----Original Message----- Private Sub Worksheet_Activate() macro2 end Sub -- HTH Richard Choate, CPA "SpeeD" wrote in message ... Hi guys. I have to call a macro (macro2) from wthin "Private Sub Worksheet_Activate()" How can i do this? Thanks!!! SpeeD . |
Rum macro in procedure
Hi
I´ve tried to write this formula in a cell (c17), but simply doens´t work. What am i missing?? thanks! SpeeD -----Original Message----- IF cell (a,b) = ... THEN Call macro END IF "SpeeD" wrote in message ... Thanks a lot! By the way if i want to run a macro from a "IF" formula in a cell, how can i do it?? Thanks!!!!! -----Original Message----- Private Sub Worksheet_Activate() macro2 end Sub -- HTH Richard Choate, CPA "SpeeD" wrote in message ... Hi guys. I have to call a macro (macro2) from wthin "Private Sub Worksheet_Activate()" How can i do this? Thanks!!! SpeeD . . |
Rum macro in procedure
You can't do that directly from a formula, but you can code it to
happen based on a set of conditions. What conditions do you want to cause this macro to fire? On Thu, 7 Aug 2003 06:22:02 -0700, "SpeeD72" wrote: Hi I´ve tried to write this formula in a cell (c17), but simply doens´t work. What am i missing?? thanks! SpeeD -----Original Message----- IF cell (a,b) = ... THEN Call macro END IF "SpeeD" wrote in message ... Thanks a lot! By the way if i want to run a macro from a "IF" formula in a cell, how can i do it?? Thanks!!!!! -----Original Message----- Private Sub Worksheet_Activate() macro2 end Sub -- HTH Richard Choate, CPA "SpeeD" wrote in message ... Hi guys. I have to call a macro (macro2) from wthin "Private Sub Worksheet_Activate()" How can i do this? Thanks!!! SpeeD . . |
All times are GMT +1. The time now is 12:30 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com