| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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!?!) |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!?!) |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!?!) |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!?!) |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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!?!) |
|
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macro Help Needed - Excel 2007 - Print Macro with Auto Sort | Excel Worksheet Functions | |||
| My excel macro recorder no longer shows up when recording macro | Excel Discussion (Misc queries) | |||
| Need syntax for RUNning a Word macro with an argument, called from an Excel macro | Excel Programming | |||
| translate lotus 1-2-3 macro into excel macro using excel 2000 | Excel Programming | |||
Linear Mode
