Can a Macro be run as part of an IF() statement
You cannot do it in a formula but event code could run the macro when A1=1
Private Sub Worksheet_Calculate()
On Error GoTo stoppit
Application.EnableEvents = False
With Me.Range("A1")
If .Value = 1 Then
'MsgBox "Please be advised that A1 is equal to 1"
Macroname
End If
End With
stoppit:
Application.EnableEvents = True
End Sub
Gord Dibben MS Excel MVP
On Thu, 4 Oct 2007 20:15:01 -0700, WAJ wrote:
Can I run a macro as part of an IF statement i.e. IF(A2=1,Run Macro 1,Do
nothing ) I simplified what I want to happen but I want to automatically run
a macro when a condition goes true in another cell.
|