Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Can a macro be made to work based on a formula?
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
Addendum: a Worksheet event macro like Worksheet_Calculate or Worksheet_Change
can monitor the results in a given cell and run more code if the value meets your criteria. On Tue, 25 Jan 2005 21:57:45 -0600, Myrna Larson wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can a macro be made to work based on a formula? | Excel Discussion (Misc queries) | |||
Excel 97 - Adding Every 8th Row - Formula should work, but doesn't | Excel Worksheet Functions | |||
Formula to return cell contents based on multiple conditions | Excel Worksheet Functions | |||
Help with macro formula and variable | Excel Worksheet Functions | |||
Macro Formula revision? | Excel Worksheet Functions |