In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
 

I need a macro to play a wav sound file called "alarm.wav" located in
C:\Documents and Settings\HOME\My Documents\My Excel

the macro to run when =IF(A1<=B1,100,0) gives an answer of 100

(and for all other calculations to continue when it is playing if possible!?!)

In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
 

You want it to play everytime there is a recalculation and the cell
continues to show 100?

http://www.j-walk.com/ss/excel/tips/tip87.htm

--
Regards,
Tom Ogilvy



"RenewableEnergy" wrote in
message ...
I need a macro to play a wav sound file called "alarm.wav" located in
C:\Documents and Settings\HOME\My Documents\My Excel

the macro to run when =IF(A1<=B1,100,0) gives an answer of 100

(and for all other calculations to continue when it is playing if
possible!?!)

In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
 

YES PLEASE !

"Tom Ogilvy" wrote:

You want it to play everytime there is a recalculation and the cell
continues to show 100?

http://www.j-walk.com/ss/excel/tips/tip87.htm

--
Regards,
Tom Ogilvy



"RenewableEnergy" wrote in
message ...
I need a macro to play a wav sound file called "alarm.wav" located in
C:\Documents and Settings\HOME\My Documents\My Excel

the macro to run when =IF(A1<=B1,100,0) gives an answer of 100

(and for all other calculations to continue when it is playing if
possible!?!)

In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
 

THANKS FOR THE LINK, BUT i STILL CAN'T GET IT ERROR PROOF

"Tom Ogilvy" wrote:

You want it to play everytime there is a recalculation and the cell
continues to show 100?

http://www.j-walk.com/ss/excel/tips/tip87.htm

--
Regards,
Tom Ogilvy



"RenewableEnergy" wrote in
message ...
I need a macro to play a wav sound file called "alarm.wav" located in
C:\Documents and Settings\HOME\My Documents\My Excel

the macro to run when =IF(A1<=B1,100,0) gives an answer of 100

(and for all other calculations to continue when it is playing if
possible!?!)

In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
 

Running Excel 2003 SP2

"Tom Ogilvy" wrote:

You want it to play everytime there is a recalculation and the cell
continues to show 100?

http://www.j-walk.com/ss/excel/tips/tip87.htm

--
Regards,
Tom Ogilvy



"RenewableEnergy" wrote in
message ...
I need a macro to play a wav sound file called "alarm.wav" located in
C:\Documents and Settings\HOME\My Documents\My Excel

the macro to run when =IF(A1<=B1,100,0) gives an answer of 100

(and for all other calculations to continue when it is playing if
possible!?!)

In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
 

GOT IT ! Thanks!!!

"Tom Ogilvy" wrote:

You want it to play everytime there is a recalculation and the cell
continues to show 100?

http://www.j-walk.com/ss/excel/tips/tip87.htm

--
Regards,
Tom Ogilvy



"RenewableEnergy" wrote in
message ...
I need a macro to play a wav sound file called "alarm.wav" located in
C:\Documents and Settings\HOME\My Documents\My Excel

the macro to run when =IF(A1<=B1,100,0) gives an answer of 100

(and for all other calculations to continue when it is playing if
possible!?!)