Creating sound alert in excel on change in text of a cell?

[Loki1203]

I have imported a stock list in excel and have done some calculations. This sheet gets updated from internet every second. Now I have used the vlookup formula in cell A1 to get the stock name against the maximum value. Now i want excel to play a specific sound (not beep) when the text of the Cell A1 changes. Please help me in doing this.

Note - The sheet gets updated every second from internet and the text of Cell A1 may or may not change. There is no manual intervention in changing the cell.

 

[Yongle]

Have a look at this tip from Allen Wyatt titled Conditionally Playing an Audio File
- tailor to match your requirements
- you may need to combine this with a macro which triggers when values are updated from internet

https://excel.tips.net/T006559_Conditionally_Playing_an_Audio_File.html

 

[Yongle]

Placing a volatile formula in a cell in (internet-updated) worksheet triggers event macro Worksheet_Calculate when updates occur
Combining that with previous suggestion should play your sound

1 Place this formula in any cell outside the Table
=NOW()
2 Add code below (suggest you test with Beep before using your own macro)
3 Go back to Excel and wait for the sound

Goes in SHEET module (right-click sheet tab \ select View Code \ paste code into code window \ back to Excel {ALT}{F11}

Private OldA1 As String          '[COLOR=#ff0000][I]ensure this line is placed above all procedures [/I][/COLOR]

Private Sub Worksheet_Calculate()
    If OldA1 <> CStr(Range("A1")) Then Call MakeNoise
    OldA1 = CStr(Range("A1"))
End Sub

Sub MakeNoise()
    'replace Beep with whatever you are using to play your sound
    Beep
End Sub