software

Conditional formatting.

Is it possible to insert logic formulae to make specific sounds based on
computed cell values in an Excel worksheet?

----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the quot;I
Agreequot; button in the message pane. If you do not see the button, follow this
link to open the suggestion in the Microsoft Web-based Newsreader and then
click quot;I Agreequot; in the message pane.

www.microsoft.com/office/comm...excel.newusers

Howard,

You can play sounds using VBA code within the calculation event:

Add this to a module:

Declare Function sndPlaySound32 Lib quot;winmm.dllquot; Alias _
quot;sndPlaySoundAquot; (ByVal lpszSoundName As String, _
ByVal uFlags As Long) As Long

Sub PlayMySound()
'Change the filepath and name
Call sndPlaySound32(quot;c:\folder\Filename.WAVquot;, 0)
End Sub

Add this worksheet event

Private Sub Worksheet_Calculate()
If Range(quot;A1quot;).Value lt;gt; Range(quot;A2quot;).Value Then
Application.EnableEvents = False
PlayMySound
Range(quot;A2quot;).Value = Range(quot;A1quot;).Value
Application.EnableEvents = True
End If
End SubHTH,
Bernie
MS Excel MVPquot; mgt; wrote in message
...
gt; Conditional formatting.
gt;
gt; Is it possible to insert logic formulae to make specific sounds based on
gt; computed cell values in an Excel worksheet?
gt;
gt; ----------------
gt; This post is a suggestion for Microsoft, and Microsoft responds to the
gt; suggestions with the most votes. To vote for this suggestion, click the quot;I
gt; Agreequot; button in the message pane. If you do not see the button, follow this
gt; link to open the suggestion in the Microsoft Web-based Newsreader and then
gt; click quot;I Agreequot; in the message pane.
gt;
gt; www.microsoft.com/office/comm...excel.newusers