Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use an IF statement to launch a macro?
Is it possible to use an IF statement in cell b1 to launch a desired
macro if a1 equals the value specified in the IF statement? ie say IF a1 = "ABC" then the IF statement in b1 would recognise this and launch macro1? Does anyone know if this is possible or impossible? It would be fantastic to learn that its possible!!! --- Message posted from http://www.ExcelForum.com/ |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use an IF statement to launch a macro?
No!
You could use worksheet event code though Private Sub Worksheet_Change(ByVal Target As Range) If Target.Address(False, False) = "A1" Then If Target.Value = "ABC" Then macro1 End If End If End Sub This would go into the worksheet code module -- HTH Bob Phillips ... looking out across Poole Harbour to the Purbecks (remove nothere from the email address if mailing direct) "ian123 " wrote in message ... Is it possible to use an IF statement in cell b1 to launch a desired macro if a1 equals the value specified in the IF statement? ie say IF a1 = "ABC" then the IF statement in b1 would recognise this and launch macro1? Does anyone know if this is possible or impossible? It would be fantastic to learn that its possible!!! --- Message posted from http://www.ExcelForum.com/ |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use an IF statement to launch a macro?
Sure. You can. Let's create the following two simple macros. One is custom worksheet function, the second on the a subroutine which pops up a msgbox
Function testing( hello_macr End Functio Sub hello_macro( MsgBox "hello End Su In cell B1, you type the following formula =IF(A1="ABC",testing(),"" Change cell A1 to see the effect ----- ian123 wrote: ---- Is it possible to use an IF statement in cell b1 to launch a desire macro if a1 equals the value specified in the IF statement ie say IF a1 = "ABC" then the IF statement in b1 would recognise thi and launch macro1 Does anyone know if this is possible or impossible? It would b fantastic to learn that its possible!! -- Message posted from http://www.ExcelForum.com |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Can you use an IF statement to launch a macro?
Just be advised that you would be restricted to many severe limitations
imposed on code called from a cell. Also, as long as the condition is met, each time there was a calculate, the code would be executed. -- Regards, Tom Ogilvy Edwin Tam wrote in message ... Sure. You can. Let's create the following two simple macros. One is custom worksheet function, the second on the a subroutine which pops up a msgbox. Function testing() hello_macro End Function Sub hello_macro() MsgBox "hello" End Sub In cell B1, you type the following formula: =IF(A1="ABC",testing(),"") Change cell A1 to see the effect. ----- ian123 wrote: ----- Is it possible to use an IF statement in cell b1 to launch a desired macro if a1 equals the value specified in the IF statement? ie say IF a1 = "ABC" then the IF statement in b1 would recognise this and launch macro1? Does anyone know if this is possible or impossible? It would be fantastic to learn that its possible!!! --- Message posted from http://www.ExcelForum.com/ |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Auto Launch of Macro | Excel Discussion (Misc queries) | |||
Macro to launch web page | Excel Discussion (Misc queries) | |||
Automatically launch a macro when a fil is opened | Excel Discussion (Misc queries) | |||
auto-launch a MACRO? | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |