Need a click, beep, or a burp
 

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.

Need a click, beep, or a burp
 

hi
at the end of your macro,just before end sub, type the word Beep.

regards
FSt1

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

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.

Need a click, beep, or a burp
 

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.

Seems like a strange request. From my knowledge, you can't use the PC speaker
with VB, C can do it.

Can I ask, why not use speaker sound?

--
Anthony Prescott
http://www.apofficesolutions.co.uk

Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...mming/200902/1