How do I "call" a macro as part of an 'if' statement

[Dragman]

I am trying to call a macro as part of an 'if' statement as follows:

=IF(Summary!C5="No",call.macro3,"No AP Required")

I am sure it is a syntax error? What would be the proper wording for this?

The more I use this site the more knowledgeable I become.

Thanks for the help....


Dragman

[romperstomper]

You cannot call a macro from a cell. You can convert it to a function and call that, but whether it will work depends on what the routine does. There are strict rules about what functions called from cells can do.

[Dragman]

So how do I convert it to a function? I want it to delete rows in one worksheet based upon the value of a cell in another worksheet.

[tuongtu3]

How about below:

Sub CallMacro3()
Dim ws As Worksheet
Set ws = Worksheets("Summary")
If ws.Range("C5").Value = "No" Then
Call Macro3
Else
ws.Range("C5").Value = "No AP Required"
End If
End Sub

Sub Macro3()
MsgBox "Bingo"  '''enter your code here
End Sub

Regards,
tt3