Use IF function to automatic run macro

[YS Lee]

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...heet.functions

[Niek Otten]

Not possible that way.
But look at Event procedures:

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

--
Kind regards,

Niek Otten

"YS Lee" <YS [email protected]> wrote in message news:[email protected]...
|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...heet.functions

[Ronald Dodge]

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 [email protected]> wrote in message
news:[email protected]...
> 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...heet.functions