using macro within an if function

  • Thread starter Thread starter Guest
  • Start date Start date
Hi Ben!

Formulas only return values to a cell.

But you can use a Worksheet_change event handling macro that will run
based upon the results of a target cell.

A Google search on Worksheet_change should produce lots of examples
that might be tailored to your requirements. Or you could post more
details of what you intend.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
Ben said:
Can you put macros into formulas to run automatically if special
criteria is met?
 
Back
Top