Google-sheets – How to set Audio alert in Google spreadsheet that triggers by a specific value

google sheets

Can I set an Audio alert in a Google spreadsheet cell that triggers whenever it changes a specific value?

I want some thing similar to "beepnow" function which is using in MS Excel VBA.

Best Answer

Short answer

At this time it's not possible to trigger an audio alert through an on edit event without opening and HTML sidebar or dialog.

Explanation

The equivalent to Excel VBA is Google Apps Script which is based on JavaScript. Unfortunately they don't include a class for sounds.

The answer by Mogsdad to the referred Stack Overflow question in a comment by user 79865 use the audio tag from HTML5, that could be used in an HTML side bar or dialog but not alone.