Can a Macro be run as part of an IF() statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
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
 
Back
Top