| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Sound repeats unending until closing workbook
On Friday, June 21, 2013 2:38:45 AM UTC-7, Claus Busch wrote:
Hi Howard, Am Fri, 21 Jun 2013 02:15:58 -0700 (PDT) schrieb Howard: SoundPlayAsyncLoop Sheets("Sheet1").Range("F1").Text SoundPlayAsyncOnce Sheets("Sheet1").Range("F1").Text SoundPlayAsyncLoop Sheets("Sheet1").Range("G1").Text SoundPlayAsyncOnce Sheets("Sheet1").Range("G1").Text Regards Claus Busch Well, I sorta was on the right track. I copied from this part of code and missed the part about "SoundStop". Even being curious about the ...Loop portion, it slipped by me. My bad, DUH! And I thank you for pointing out the obvious. Regards, Howard If .Value <= WarningTime Then SoundPlayAsyncLoop Sheets("Main").Range("F1").Text End If Wend If (.Value <= Period) Then SoundStop .Value = "Time Up!" End If |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| play sound when closing xcel 2007 | Excel Discussion (Misc queries) | |||
| copy and paste VBA repeats and repeats | Excel Discussion (Misc queries) | |||
| Closing a workbook from a macro doesn't close the workbook | Excel Programming | |||
| play sound when opening workbook | Excel Programming | |||
| closing excel after closing a workbook | Excel Programming | |||
Threaded Mode
