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;
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.