Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi guys.
I have to call a macro (macro2) from wthin "Private Sub Worksheet_Activate()" How can i do this? Thanks!!! SpeeD |
#2
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
#3
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . |
#4
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . . |
#5
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 . . |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Invalid outside procedure (creating a PDF button as a macro) | Excel Worksheet Functions | |||
Stop a Procedure from another procedure | Excel Discussion (Misc queries) | |||
hyperlink, macro, stored procedure? | Excel Worksheet Functions | |||
start a macro or procedure based on user putting an x in a cell | Excel Discussion (Misc queries) |