Can you use an IF statement to launch a macro?

I

ian123

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!!!
 
B

Bob Phillips

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)
 
E

Edwin Tam

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!!
 
T

Tom Ogilvy

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 said:
Sure. You can. Let's create the following two simple macros. One is custom
Click to expand...
worksheet function, the second on the a subroutine which pops up a msgbox.
 
Top