Conditionally Making a Sound

New Contributor

Hi Excel friends, hope you can help me! 


I am trying to play a sound when a condition in a specific cell is met (cell value is higher than for example 20)


I have tried to use the VBA script on

but when I use the formula =IF(A1>300,BeepMe(),"") I get an error message: "there is an errow in your formula.


Does anyone know what the problem is? (I am using Office professional plus 2016 32 bit)


Thanks you very much!



2 Replies

Hi @Excel1020 


Not sure what your issue is but have attached a sample file done with the instructions from the second link in your post, which works perfectly. The function is saved in module1.







Thank you so much Rich99, based on you spreadsheet I found where I went wrong!

Right is

Instead of

And I did not add a module to add the VBA script (I am a newbee to VBA)

Related Conversations
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
Edge insider Dev bypasses IE mode website list
HotCakeX in Enterprise on
4 Replies