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 https://excelribbon.tips.net/T005834_Conditionally_Making_a_Sound.html
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!
View best response
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!
And I did not add a module to add the VBA script (I am a newbee to VBA)