Get a sound notification in an excel spreadsheet

[ramzi_007]

Hello,

I really need your urgent help,
i wonder if there's anyway of playing a sound whenever a specific cell equals a certain value
This has to happen automatically as the cell updates and require no interaction.
Any suggestions would be appreciated.

i've found some VBA codes, but as a beginner i don't know how to use them and i should deliver my work on this week.

Copy the code below to a VBA module in your workbook.

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

Function Alarm(Cell, Condition)
Dim WAVFile As String
Const SND_ASYNC = &H1
Const SND_FILENAME = &H20000
On Error GoTo ErrHandler
If Evaluate(Cell.Value & Condition) Then
WAVFile = ThisWorkbook.Path & "\sound.wav" 'Edit this statement
Call PlaySound(WAVFile, 0&, SND_ASYNC Or SND_FILENAME)
Alarm = True
Exit Function
End If
ErrHandler:
Alarm = False
End Function

NOTE: The Alarm function expects a WAV file (named sound.wav) in the same path as the workbook. You will need to change this statement to match the name (and path) of your actual sound file. If the sound file is not found, the default system sound will be used.

[mrice]

Try pasting this into the Sheet1 tab on the VBA Editor for instance.

Please Login or Register  to view this content.

[ramzi_007]

Hello mrice,

Thank you so much for your reply

i will explain what i really need, ( not sure if this can be done )

there will be a principal sheet, and other sheets that are categorized ( EX: Product 1, Product 2 ...), and each Product sheet contains some item numbers.

in the principal sheet i will put some item numbers, what i really want is when i past an item number, a sound will say in which category it belongs.

can this be done ? i would appreaciate your help

[ramzi_007]

anybody can help ?

[alansidman]

Look at this link to learn about VBA and Sounds.

http://www.cpearson.com/excel/PlaySound.aspx

Here is some info on playing MP3 files in VBA

http://spreadsheetpage.com/index.php...es_from_excel/

[ramzi_007]

Thank you so much ALANSIDMAN i will take a look on it, but i'm really pressed by time, not sure if i could realize mo project this weekend