A formula in a worksheet cell can call a function written in VBA. But that
function can only return a result to the cell containing the formula, just
like the built-in functions like SUM and AVERAGE do. The code can't change
other cells, do formatting, etc.


On Tue, 25 Jan 2005 18:59:04 -0800, "lonnied"
wrote:

Is it possible to have a macro run based on the answer to a question? If the
answer to a certain question is yes then the macro would run.