Forum Discussion

Excel1020's avatar
Excel1020
Copper Contributor
Sep 23, 2019
Solved

Conditionally Making a Sound

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 o...
excel
Macros and VBA
  • Rich99's avatar
    Rich99
    Sep 24, 2019

    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.

     

    Regards

     

    Rich99

Rich99's avatar
Rich99
Iron Contributor
Sep 24, 2019

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.

 

Regards

 

Rich99

  • Excel1020's avatar
    Excel1020
    Copper Contributor
    Sep 24, 2019

    Rich99 

     

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

    Right is
    =IF(C20>0,15;SoundMe())

    Instead of
    =IF(A1>300,SoundMe(),"")

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

Resources