+ Reply to Thread
Results 1 to 17 of 17

Sound alert when specific value is triggered (worksheet attached)

  1. #1
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Sound alert when specific value is triggered (worksheet attached)

    Good Morning Everyone,

    Thanks for taking the time to look at this one.

    I have attached a worksheet and would really appreciate help with the following:


    1. I need an audio alert to be triggered when one cell value in the range (A11:M11) is greater than or equal to 50.

    2. I also need an audio alert to be triggered when one cell value in the range (A11:M11) is less than or equal to -50.


    The numbers are generated through a dynamic data feed.

    The audio alert can be the same sound for both values (e.g. "C: Windows Media Ring 03" is the location of one sound on my computer).

    Could somebody please create a macro for this, and paste it in so that it runs automatically from when I open the document?

    Alternatively, if it is possible (and easier) to do this using conditional formatting, please feel free to do so.

    Looking forward to receiving your answers!
    Attached Files Attached Files

  2. #2
    Forum Expert
    Join Date
    11-24-2013
    Location
    Paris, France
    MS-Off Ver
    Excel 2003 / 2010
    Posts
    5,124

    Re: Sound alert when specific value is triggered (worksheet attached)


    Hi,

    CF can highlight cells lower or upper a value …

  3. #3
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Sound alert when specific value is triggered (worksheet attached)

    Hi Marc,

    Thanks for your response. Sure thing, it's just that I require an audio alert and do not know how to programme this.

  4. #4
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,785

    Re: Sound alert when specific value is triggered (worksheet attached)

    Something like this?

    Please Login or Register  to view this content.
    Cheers!
    Deep Dave

    www.NeedForExcel.com

  5. #5
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Sound alert when specific value is triggered (worksheet attached)

    Hi there,

    That looks great, could you paste it into the workbook for me, please? (I am not familiar with VBA).

    Many thanks!

  6. #6
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,785

    Re: Sound alert when specific value is triggered (worksheet attached)

    Here you go..

    make sure Macros are enabled.
    Attached Files Attached Files

  7. #7
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Sound alert when specific value is triggered (worksheet attached)

    Thanks very much!

  8. #8
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,785

    Re: Sound alert when specific value is triggered (worksheet attached)

    Did it work for you?

  9. #9
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Sound alert when specific value is triggered (worksheet attached)

    Hi,

    Yes thanks :-) I'm just trying to get it to work automatically from the moment the document is opened, so that I do not have to manually activate it by pressing f5.

    Could you maybe make it do this?

    Many thanks in advance

  10. #10
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,785

    Re: Sound alert when specific value is triggered (worksheet attached)

    Alright,

    Can you tell me what this exactly means?

    when one cell value in the range (A11:M11) is greater than or equal to 50.
    What if there are more than one such cells?

  11. #11
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Sound alert when specific value is triggered (worksheet attached)

    Sure thing,

    the dynamic data values are listed on a worksheet entitled "RESULTS" and change every second in the range A11:M11, as part of a larger Excel file I have been building.

    When one (or several) cells display a value >= 50 or <=-50 in any given second, it would be great if Excel could announce "ALERT" or something similar just once. Does this information help?

  12. #12
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,785

    Re: Sound alert when specific value is triggered (worksheet attached)

    Alright!

    Then why not have CF to make the Cell Red when cells display a value >= 50 or <=-50?

    I mean I can give you a sound alert, but wont that be irritating after some time?

    Besides, CF will tell you exactly the cells that have violated the Rules..

  13. #13
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Sound alert when specific value is triggered (worksheet attached)

    Hi,

    yeah, I know it seems crazy. It's just that I can't always be in front of my screen if I have it running in the office or at home, but I'm always within earshot of the laptop (I have two young daughters who keep me very busy :-))

    So, with a sound alert, I could be in the other room and know when an alert has been triggered, but would not necessarily see it.

    Besides, the trading algorithm tends to generate one alert value every 45 minutes (on average) so it would not be too annoying.

    Would it still be OK to have the sound alert instead?

  14. #14
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,785

    Re: Sound alert when specific value is triggered (worksheet attached)

    Try this -

    Use F9 to recalculate the dummy data
    Attached Files Attached Files

  15. #15
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Sound alert when specific value is triggered (worksheet attached)

    Yes, perfect!

    Thank you very much for your help! I really appreciate it.

  16. #16
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019
    Posts
    3,785

    Re: Sound alert when specific value is triggered (worksheet attached)

    Glad to have helped..

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.

  17. #17
    Registered User
    Join Date
    12-12-2014
    Location
    Dorset, England
    MS-Off Ver
    Excel 2013
    Posts
    54

    Re: Sound alert when specific value is triggered (worksheet attached)

    Sure thing :-)

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Sound Alert
    By Raj Mukherji in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-23-2014, 11:41 AM
  2. [SOLVED] Sound Alert as a cell value changes
    By mrdog in forum Excel General
    Replies: 23
    Last Post: 02-28-2014, 03:26 PM
  3. sound alert from excel
    By dan in forum Excel General
    Replies: 0
    Last Post: 06-25-2006, 10:55 PM
  4. [SOLVED] Sound alert
    By Antonio in forum Excel General
    Replies: 3
    Last Post: 05-30-2006, 02:15 PM
  5. Sound+color alert if cell changed in another worksheet
    By florinel in forum Excel General
    Replies: 0
    Last Post: 05-25-2006, 11:52 AM
  6. Sound / Audible Alert in a Woksheet ?
    By Bob Phillips in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-06-2005, 04:05 AM
  7. Sound / Audible Alert in a Woksheet ?
    By carl in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 09-05-2005, 11:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1