+ Reply to Thread
Results 1 to 6 of 6

Sound file in Excel

  1. #1
    Registered User
    Join Date
    01-17-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, & 2010 Beta
    Posts
    78

    Sound file in Excel

    I've a spreadsheet in which there is a possible 'error' scenario, and the word "Error!" appears, if that happens, to alert the user in - let's just say cell A1. What I'd like to add is some [couple of seconds] alarm type sound which would go off whenever cell A1 displays the word "Error!". I was thinking of some brief air-raid siren sound, and maybe that could be inserted into cell B1. So: B1 activates if A1 displays "Error!". Hope someone can help me set up something like that, thanks.
    Lotusman

  2. #2
    Forum Moderator - RIP Richard Buttrey's Avatar
    Join Date
    01-14-2008
    Location
    Stockton Heath, Cheshire, UK
    MS-Off Ver
    Office 365, Excel for Windows 2010 & Excel for Mac
    Posts
    29,464

    Re: Sound file in Excel

    Maybe a sheet change event macro which reacts to whatever causes A1 to display "Error"

    i.e.

    Please Login or Register  to view this content.
    Richard Buttrey

    RIP - d. 06/10/2022

    If any of the responses have helped then please consider rating them by clicking the small star icon below the post.

  3. #3
    Registered User
    Join Date
    01-17-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, & 2010 Beta
    Posts
    78

    Re: Sound file in Excel

    Hi, Richard,
    Thanks for this. Tell me, if you can, how I build a macro around this. I've a cell with range name "ErrorFlag" that displays "Error!" in certain circumstances.
    I'd like to set up a sound 'reaction' to a particular value upon occurence in that cell (ErrorFlag) - how would I do that? Thanks,
    Lotusman
    Last edited by lotusman; 10-31-2017 at 04:34 AM. Reason: I was ticked off about 'the Rules':-)

  4. #4
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2003, 2010
    Posts
    40,678

    Re: Sound file in Excel

    Please take a few minutes to reread the forum rules, and then edit your post to add CODE tags.

    Thanks.
    Entia non sunt multiplicanda sine necessitate

  5. #5
    Registered User
    Join Date
    01-17-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, & 2010 Beta
    Posts
    78
    Quote Originally Posted by shg View Post
    Please take a few minutes to reread the forum rules, and then edit your post to add CODE tags.

    Thanks.
    Shg, tell me if something's wrong with my submission...I don't know anything about code tags...

  6. #6
    Registered User
    Join Date
    01-17-2010
    Location
    London, England
    MS-Off Ver
    Excel 2003, 2007, & 2010 Beta
    Posts
    78

    Re: Sound file in Excel

    Just tried this out, Richard, and it worked! Thanks very much. Shall explore other sounds, if I can find them. Is there a set of Sound Objects in VBA somewhere perhaps?
    Lotusman...

+ 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. Play sound file at set time each day
    By thetaplus in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 12-23-2008, 01:03 AM
  2. excel to play sound file
    By svanni in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 11-03-2006, 11:47 PM
  3. [SOLVED] Play Sound File
    By Soniya in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2006, 06:50 AM
  4. Playing a sound file from Excel
    By Larry in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 02-10-2006, 02:50 PM
  5. Can Excel or Access activate a sound file based on a cell value?
    By huzorba in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2005, 06:20 PM
  6. [SOLVED] How do you add sound file to a cell in excel
    By Martin in forum Excel Formulas & Functions
    Replies: 10
    Last Post: 05-01-2005, 09:06 PM
  7. [SOLVED] How do I enter a wave sound file into an excel cell?
    By dkimball in forum Excel General
    Replies: 2
    Last Post: 03-28-2005, 04:06 PM
  8. can VBA be used to sound a *.wav file on condition(s)?
    By J_J in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 02-23-2005, 04:06 PM

Tags for this Thread

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