using macro within an if function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Can you put macros into formulas to run automatically if special criteria is met?
 
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?
 

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

Back
Top