sound

What is the difference between .clear and .clearcontents? They sound like they do the same thing.

Hi people, I am using a excel file where stock quotes are keep updating for every second. During the process when random errors occurs excel sheet will show error messages. I want some sound alarms whenever any message box appears or the sheet stopped updating latest quotes. Thanks in advance.

Hi, I am using the below code to play a .wav file which acts like a wake up alarm. The .wav file is 8 mins long so that I definitely wake up. But while the alarm/.wav is playing I would like to be able to mute the sound for 30 seconds if the spacebar is pressed (so that I have time to wake up...

Hi all, I would like to know how to make excel play a sound when a specific change occurs. For example, I have a range of cells (F6 to F50) with formula within the cells. They are blank at first (which is normal). When the stock market moves, some of the cells (say F8 and F25) are "Triggered"...

I'm trying to set up VBA and logical test so that if A1 is greater than B6, a sound clip will play, alerting me even from my sleep. Here are the codes. VBA: Logical question in the cell: Now, the problem is that the sound plays regardless of the logic function. It plays whether A1 is...

Can someone send me a simple Excel spreadsheet that will play a sound wav file. I have read a lot of posts and still could not understand how to do it. I just need a simple Excel spread sheet that will play a "correct" sound file when cell a1 = b1. Is it OK to post my email address in this...

good evening, i have a excelfile with a complete competition of a volleybal tournament. what i am looking for is a code that calls out specific sound files (team names spoken) when a specific team needs to play in the next round of the tournament i hope some1 can help me out. best regards...

HI I want to play music while a form is open, and when someone clicks on a text box in the form for a sound effect to play like a bell chime or something, and when they click another button on the form another sound effect. Is there a simple line of code that can do this? THanks

Good Day Everyone, I am trying to understand the limitation of Excel, In The Year 2017, as it relates to playing music/audio extension files via VBA. I have seen successful ways of playing WAV sound files without visually opening an additional music player program. Can someone PLEASE tell me...

Hi guyz i have been google for days trying to find solution to put time-stamp and sound when condition meet. i really hope all expert excel user here can help me. This is what i want to do: eg: =IF((F9="SELL")*AND(H9="GOOD"),"SELL"&"",IF((F9="BUY")*AND(H9="GOOD"),"BUY")) It will trigger...

I need help with this spreadsheet. We cannot load the sound files on computers, so the files need to be embedded. They can be a wav or an mp3. The spreadshet is used to track projected hours for each store. Ideally we would like a cash register sound (green.wav) to play when the value is...

here is code that works good until it repeats and does not end until manual stop - help Sub PLAYSONG() REQ_B = 100001 'skip1 for PLAY_Q test ' GoTo NOK 'skip1 end Application.ScreenUpdating = False If REQ_B > 199999 Then GoTo NOK Else DR_L = ActiveCell.Address...

Hello, hopefully someone can help me with this request. In column A I will be entering a list of product codes, without looking at the screen. I want Excel to play a designated audio file when a duplicate value is entered, so I am alerted that it is a duplicate and can take appropriate action...

Hi, Im working on Excel 2007 and I have a table of our sales orders that updates automatically on a Microsoft Query. From this I've done a Count formula to tell me how many orders there are for today. What is was wanting to do is have a sound play, preferably a .wav whenever a new order comes...