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/