sound alert if any error occurs

[vijayamani1987]

Hi people,

I am using a excel file where stock quotes are keep updating for every second. During the process when random errors occurs excel sheet will show error messages. I want some sound alarms whenever any message box appears or the sheet stopped updating latest quotes. Thanks in advance.

 

[Kamolga]

Hi,

You can create a Beep function

Function ErrorBeep
Beep
End function

and then if your link is in A1, use

 =iferror(A1;errorBeep())