software

I want to use the IF function to automatic run my macro when the condition is
true or false. Currently the macro need to run by mouse click or keyboard
shortcut .

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...et.f unctions

Not possible that way.
But look at Event procedures:

www.cpearson.com/excel/events.htm

--
Kind regards,

Niek Otten

quot;YS Leequot; lt;YS gt; wrote in message ...
|I want to use the IF function to automatic run my macro when the condition is
| true or false. Currently the macro need to run by mouse click or keyboard
| shortcut .
|
| ----------------
| This post is a suggestion for Microsoft, and Microsoft responds to the
| suggestions with the most votes. To vote for this suggestion, click the quot;I
| Agreequot; button in the message pane. If you do not see the button, follow this
| link to open the suggestion in the Microsoft Web-based Newsreader and then
| click quot;I Agreequot; in the message pane.
|
|
www.microsoft.com/office/comm...et.f unctions
The only way to possibly get this to work the way you want it to work is to
run it via the Calculate Event of either the Worksheet or the Workbook.
However, this would only take place when the calculation of that formula has
taken place within the cell that it's located in.

--
Ronald R. Dodge, Jr.
Production Statistician/Programmer
Master MOUS 2000

quot;YS Leequot; lt;YS gt; wrote in message
...
gt; I want to use the IF function to automatic run my macro when the condition
is
gt; true or false. Currently the macro need to run by mouse click or keyboard
gt; shortcut .
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow
this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt;
www.microsoft.com/office/comm...et.f unctions