sound alert if any error occurs

vijayamani1987

New Member
Joined
Mar 16, 2014
Messages
32
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.
 
Last edited:

Some videos you may like

Excel Facts

Repeat Last Command
Pressing F4 adds dollar signs when editing a formula. When not editing, F4 repeats last command.

Kamolga

Well-known Member
Joined
Jan 28, 2015
Messages
1,171
Hi,

You can create a Beep function
Code:
Function ErrorBeep
Beep
End function
and then if your link is in A1, use
Code:
 =iferror(A1;errorBeep())
 
Last edited:

Watch MrExcel Video

Forum statistics

Threads
1,095,669
Messages
5,445,867
Members
405,363
Latest member
proudsprinkles

This Week's Hot Topics

Top