Good days;
I want to get a sound alarm when a cell’s value is changed. As you see on the picture, in AZ1 cell I have this formula: =IF(MAX(AZ4:AZ235)>=5;”BUYING ALARM”;””)
In this Sheet’s code view I have;
Code
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("AZ1")) Is Nothing Then Exit Sub
Application.OnTime Now + TimeValue("00:00:05"), "ALARM"
End Sub
Module1 has;
Sub ALARM()
Beep
End Sub
Display More
If I change manually the value of AZ1 it works and gives BEEP after 5 seconds. This analysis program starts itself every 30 minutes and it finishes the work in 40 seconds. If there is a suitable value between AZ4:AZ235, the value of AZ1 becomes BUYING ALARM auto. But there is no alarm sound.
If you help to solve this problem and give a code that provides at least 1 minute lasting ALARM sound, I appreciate it.
Good and healty days to everybody. Thanks a lot such a forum.