Thread: In Excel a macro to run when yes =IF(A1<=B1,100,0) is 100
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
RenewableEnergy RenewableEnergy is offline
external usenet poster
  
Posts: 5
Default 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!?!)




Reply With QuoteReply With Quote