PDA

Click to See Complete Forum and Search --> : *Resolved* VBA 'Beep' Command?


TheRobster
Apr 12th, 2005, 06:27 PM
Is there a way to make Excel VBA produce a beep sound? I want the one that is produced in most Window's programs when an error occurs. Dunno what the VBA command is but the code would generally look like this:


Sub Produce_Beep()

Sound.Beep
MsgBox "An error has occured!"

End Sub


You get the idea! :D Anyone know how to do this?

Cheers
-Rob

RobDog888
Apr 12th, 2005, 07:44 PM
Beep :D

TheRobster
Apr 13th, 2005, 06:50 AM
LoL. :lol: :blush:

You know what the problem was? The command was too simple.....I was expecting something much more complicated than that...... :D

RobDog888
Apr 13th, 2005, 10:39 AM
:D I got one for you then, make it beep without using the beep function. Make it play a wav file
that is the beep sound :afrog: