Private Declare Function PlaySound Lib "winmm.dll" _īyVal hModule As Long, ByVal dwFlags As Long) As BooleanĬall PlaySound("c:\windows\media\Speech On.wav", _ģ. Private Declare PtrSafe Function PlaySound Lib "winmm.dll" _Īlias "PlaySoundA" (ByVal lpszName As String, _īyVal hModule As LongPtr, ByVal dwFlags As Long) As Boolean VBA code: Play a specific sound based on a cell value: #If Win64 Then If you want to play some other sound than the default system beep sound, here also a VBA code can do you a favor. And now, if the entered value in cell A1 is greater than 300, a default system beep sound will be played. Then save and close this code window, go back to the worksheet, and enter this formula: =IF(A1>300,BeepMe(),"") into a blank cell beside the cell contains the value you want to play a sound based on, and then press Enter key, nothing will be displayed into the formula cell, see screenshot:Ĥ. VBA code: Play a default system beep sound based on a cell value: Function BeepMe() As Stringģ. Click Insert > Module, and paste the following code in the Module Window. Hold down the ALT + F11 keys, then it opens the Microsoft Visual Basic for Applications window.Ģ. Here is a handy code for you to play a default system beep sound when a specific condition is met, please do as this:ġ. Play a sound if cell value changes in a specific column with VBA code
Play a custom sound based on cell value with VBA code Play a default system beep sound based on cell value with VBA code
Excel does not support this feature, this article, I will introduce some VBA codes to solve this task. For example, if cell value in A1 is greater than 300, I want a sound is played. In Excel, we can apply the Conditional Formatting to format and highlight the cells to meet the condition as you need, but, sometimes, you may want to play a sound if a condition is met.
#Office for mac save sounds how to
How to play a sound if a condition is met in Excel?
0 kommentar(er)
