Can you use an IF statement to launch a macro?

  • Thread starter Thread starter ian123
  • Start date Start date
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!!!
 
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)
 
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!!
 
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.
 
Back
Top