Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Want to make conditional sounds based on cell values in Excel
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 "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.newusers |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Want to make conditional sounds based on cell values in Excel
Howard,
You can play sounds using VBA code within the calculation event: Add this to a module: Declare Function sndPlaySound32 Lib "winmm.dll" Alias _ "sndPlaySoundA" (ByVal lpszSoundName As String, _ ByVal uFlags As Long) As Long Sub PlayMySound() 'Change the filepath and name Call sndPlaySound32("c:\folder\Filename.WAV", 0) End Sub Add this worksheet event Private Sub Worksheet_Calculate() If Range("A1").Value < Range("A2").Value Then Application.EnableEvents = False PlayMySound Range("A2").Value = Range("A1").Value Application.EnableEvents = True End If End Sub HTH, Bernie MS Excel MVP " m wrote in message ... 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 "I Agree" 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 "I Agree" in the message pane. http://www.microsoft.com/office/comm...excel.newusers |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to take a cell that has 3 values and make 2 more new lines | Excel Worksheet Functions | |||
Conditional Formating for a cell based on another cell's value | Excel Discussion (Misc queries) | |||
Can I make a formula in Excel to display result in same cell? | Excel Worksheet Functions | |||
How Can I make a cell flash in Excel | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |