Solved Can I make excel play a sound

Dell INSPIRON 1525
November 13, 2013 at 02:34:44
Specs: Windows 7, 2.128 GHz / 1014 MB
Can I make excel play a sound based on the output of a formula. I have been through all of the excel commands and I cant find an Insert Sound Funtion

Many Thanks

See More: Can I make excel play a sound

Report •

November 13, 2013 at 05:27:55
You will need VBA to get sound.

Here is one way:

Do a Google search on Excel Play Sound and you will get more hits.

Also, as you know, Excel questions are best asked in the Office Software forum.


Report •

November 13, 2013 at 22:52:46
✔ Best Answer
Ref Sound through excel

If On Database appears in Col X then it plays a sound

=COUNTIF($X$2:$X$2023,"On Database")

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("X1").Value = "1" Then
End If
End Sub

Private Declare Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, _
ByVal hModule As Long, ByVal dwFlags As Long) As Long

Sub PlayWav()
Dim WAVFile As String
Const SND_ASYNC = &H1
Const SND_FILENAME = &H20000
On Error GoTo ErrHandler
WAVFile = "C:\Backup\Sound.wav"
Call PlaySound(WAVFile, 0&, SND_ASYNC Or SND_FILENAME)
Exit Sub
End Sub

message edited by emory

Report •

Related Solutions

Ask Question