Need a click, beep, or a burp

F

Fan924

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.
 
J

JLGWhiz

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
 
C

Crowbar via OfficeKB.com

Top