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 "I
Agree" 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 "I Agree" in the message pane.

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

Not possible that way.
But look at Event procedures:

http://www.cpearson.com/excel/events.htm

--
Kind regards,

Niek Otten

"YS Lee" <YS 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 "I
| Agree" 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 "I Agree" in the message pane.
|
|
http://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

"YS Lee" <YS 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 "I
Agree" 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 "I Agree" in the message pane.


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