Run Macro From Within an =IF statement

[job1job1]

Is there a command that I can use within an =IF( statement to run
macro?

For example:

=IF(C2="Y",run=macroname,"N")

Thanks

 

[Ed]

Does this work?

If C2="Y" Then
RunMacro
Else
.......
End If

 

[Frank Kabel]

Hi
only possible with VBA (using an event procedure like
worksheet_change). See:
http://www.cpearson.com/excel/events.htm

 

[Frank Kabel]

Hi Ed
I think the OP wanted a formula solution

 

[Harlan Grove]

Is there a command that I can use within an =IF( statement to run a
macro?

...

No. Closest you can get is Calculate and SheetCalculate event handlers.

 

[Marcotte A]

Frank
If you changed the macro from a Sub to a Function wouldn't it work (without it being an event procedure)?

 

[Frank Kabel]

Hi
depends on what this macro should do. If it should only return a value,
no problem but if it should change formats or other cells, no chance!