Starting a macro from a formula

Posted by Joe on October 10, 2001 8:23 AM

Is there a way to start a macro from a formula.

frex; IF(C1=2,MACRO1,0)

Joe

Posted by Juan Pablo on October 10, 2001 1:41 PM

I would use the Sheet_Change event

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If Not Intersect(Target, [C1]) Is Nothing And Target = 2 Then
Macro1
End If
End Sub

Juan Pablo