View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
JLGWhiz JLGWhiz is offline
external usenet poster
 
Posts: 3,986
Default Need a click, beep, or a burp

If you want something more distiguishable than just one beep. Try this:

The first macro goes in the standard code module. The second illustrates
how to call the fisrt one. You can insert the Multibeep line into any code
and in the same workbook and it will call the macro. Just indicate the
number of desired beeps where the 3 appears in the code below.

Sub MultiBeep(NumBeeps)
For counter = 1 To NumBeeps
Beep
s = Timer + 0.5
Do While Timer < s
DoEvents
Loop
Next counter
End Sub


Sub alert()
MultiBeep 3
End Sub


"Fan924" wrote:

Not from the speakers but something from inside the PC. I need a sound
when a macro has completed. I am not even sure this can be done but I
am hoping.