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

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.
 
G

Gord Dibben

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Write a branch to another macro 4
How do I run a macro from inside an"=IF" formula in Excel 2003? 1
Pasting cell contents into a macro 1
can i use an IF Statement to run a macro? 2
With F1 value, look at A, if match or partial match return B 5
Excel TWO Instances of Excel One watching Other 3
Excel Run macro upon cell edit 0
Macro based on Cell Value 2

Top