Run Macro From Within an =IF statement

job1job1 · May 28, 2004

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 · May 28, 2004

Does this work?

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

Frank Kabel · May 28, 2004

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

Frank Kabel · May 28, 2004

Hi Ed
I think the OP wanted a formula solution :-)

Harlan Grove · May 28, 2004

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.

Guest · May 28, 2004

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

Frank Kabel · May 28, 2004

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!