Why Doesn't The Sound Play When The Value Changes Indirectly?

May 21, 2008

This is a complete mystery to me. I have some code (reproduced below) that plays a .wav file when any of the values in a1:a9 changes from 0 to greater than 0. This code works when I manually change one of the values to a trigger number in any of the cells.

The problem is that the values in a1:a9 are really pointers to other cells. For example,
a1 is "=sum(D9:D20)"

So, when I d9:d20 chnages values such that a1 changes from 0 to 5, the sound doesn't play. To put it simply, if I type "5" in a1 the sound plays. If a1 = D1 and I type "5" in D1 the value in A1 changes to 5 but the sound doesn't play.

How do I modify this code such that any change in the value of A1:A9, no matter the source of that data change, triggers the playing of the sound? ......

View 6 Replies


ADVERTISEMENT

.wav For Vb (play Sound When My Value Goes Over...)

Oct 16, 2008

This is what I have,

Private Declare Function PlaySound Lib "winmm.dll" _
Alias "PlaySoundA" (ByVal lpszName As String, _
ByVal hModule As Long, ByVal dwFlags As Long) As Long

Const SND_SYNC = &H0
Const SND_ASYNC = &H1
Const SND_FILENAME = &H20000

Private Sub Worksheet_Change(ByVal Target As Excel.Range)
If UCase(ActiveSheet.Range("S41").Value) > 99 Then
FName = "C:windowsmediading.wav"
Call PlaySound(FName, 0&, SND_ASYNC Or SND_FILENAME)
End If
End Sub

but I cant get it to work!

All I want is for it to play a sound when My Value in S41 goes over the Value 99
the value is part of a simple formula of sums.

View 9 Replies View Related

Play Sound When Cell Contains Certain Value?

Jul 13, 2013

Just want to know if there is a way to play a sound based on the value of a cell. In this case, if the cell says "S" then the sound is a low note and if the cell says "L" then the sound is a high note. If the cell is "" then there is no sound.

View 1 Replies View Related

Beep Sound Will Not Play

Jun 25, 2009

I am trying to make a sound play in excel. I have the following code in an excel spreadsheet on my computer at home. When I do the same code on my computer at work, the sound will not play.

Private Sub Worksheet_Change(ByVal Target As Range)
If Range("joe").Value > 100 Then
For x = 1 To 3
Beep
Next x
End If
End Sub

Any thoughts as to what the problem is?

View 7 Replies View Related

Play Sound Every X Seconds

Oct 17, 2007

I would like to create a macro that plays a sound every 45 seconds or so. In other words, I would like to have a countdown timer that counts from 45 seconds down to 0 seconds and at the end it plays a sound file(could be mp3, wav, etc) to signal the end. After that it should automatically reset itself back to the start of 45s and count down again. This would be repeated about ten to eleven times. What is the easiest way of doing this? It's too confusing. Lets say the audio file was located in: C:my soundseep.wav

View 2 Replies View Related

Play A Sound When Cell Condition Is Met

Dec 11, 2007

I have 2 cells that take imported info. from a DDE server. Lets say one cell currently has a number of 9.00. Lets say the 2nd cell has a number of 1.00. Lets say the 1st cell over time goes from 9.00 to 8.50 to 7.33 to 6.67 and so on....it continues to go down. At the same time, lets say the 2nd cell is gaining and going from 1.00 to 1.33 to 2.00 to 2.67 to 3.33, and so on...and it continues to go up. I want to have a certain sound play once the two cell numbers "cross" each other. I only want this sound to play one time and not every "tick" as they cross and go up/down. Can someone show me how to program this?

View 14 Replies View Related

Play Sound File At Set Time Each Day

Dec 20, 2008

I'm trying to automate/keep records of my day by setting up a spreadsheet which : 1) Plays a wav music file at a schedule time as a reminder and 2) at the same time calls up a form where I can enter the results of the activity then 3) saves the results to a sheet where consecutive daily records can be recorded and graphed.

Example

At 5am each day I want a "Motivation.wav" music file to open and play and a form appear where I enter in the number of sit ups, push-ups I get done, which I enter in the form and it gets saved to a sheet where I can graph my progress based on the results recorded.

View 12 Replies View Related

Play A Sound When A Cell Equals A Certain Value

Oct 22, 2007

Is there any way of playing a sound (or even better, speech) whenever a specific cell equals a certain value or contains a certain string (such as "Alarm")? This has to happen automatically as the cell updates and require no interaction.

View 3 Replies View Related

Play Wav Sound When Cell Is Selected

Nov 24, 2009

I have a wav sound I would like the user to hear when the cell is selected
Each cell has a word in it:

a1 = relator
a2 = woo
a3 = strategic

each word has a related recording that is in the form of a wav sound file. (does the wav filke have to be stored in a certain place...?) perused lots of Qs & As but didn't find one this simple: the user clicks the cell and the sound plays.

View 3 Replies View Related

Cell To Flash And Play A Sound

Feb 5, 2010

What I want to achieve is for say if the value in cell A1 equals the value in cell B1, then cell A1 to flash a background colour (eg. red), and also play a sound. I assume this can only be achieved using VBA, of which I am not conversant with. I am searching the forum for answers, but not yet found one that addresses my problem exactly (being a complete VBA newbie). In the meantime if some could assist please or point me to a thread that addresses this query.

View 9 Replies View Related

Play Wave Sound Then Stop Playing It

Jan 5, 2003

I'm using this simple code to play a wav file I loaded into a worksheet:

ActiveSheet.Shapes("Object 1").Select
Selection.Verb Verb = xlclose

I attached the macro to a button and it works. Now I need to stop the wave sound playing, by attaching another macro to a button. Is that possible? What syntax shall I use to stop playing the sound?

View 5 Replies View Related

Play Wave Sound Then Stop Playing It?

Sep 14, 2013

I'm using this simple code to play a wav file I loaded into a worksheet:

ActiveSheet.Shapes("Object 1").Select
Selection.Verb Verb = xlclose

I attached the macro to a button and it works. Now I need to stop the wave sound playing, by attaching another macro to a button. Is that possible? What syntax shall I use to stop playing the sound?

View 3 Replies View Related

Need To Embed A Sound File & Create A Macro To Play It..

Jan 20, 2010

embed a audio file (.wav or .mp3) into a Excel Sheet and be able to have it play from a macro? I need the Clip to stay in the file not refer to a location on the pc and have it play from the sheet not open media player. Can this be done?

View 7 Replies View Related

Indirectly Refer To Function

Oct 26, 2009

I'm trying to call a function that is stored in a cell as a text string. In cell A1, I have the text Sum('Sheet1:Sheet3'!C3). I want to call this function from a different cell. Is this possible using the pre-defined functions, or would I be better creating my own function?

View 4 Replies View Related

Userforms - Addressing Controls Indirectly

Jun 8, 2014

Is it all possible to address controls on a user form indirectly?

Thus instead of say

kv=me.textbox10.value

Could you do something like...

i=10
kfield="me.textbox" & format(i,"99") & ".value"
kv=evaluate(kfield)

View 1 Replies View Related

Indirectly Show Or Hide Grouped Data Rows

Dec 2, 2013

I have a spread sheet in which some rows are grouped.

So I can see the + (or -) buttons on the side, and the 1 and 2 buttons on the top, to hide or show the separate grouped rows.

Now, depending on the value of a certain cell, I either want to show or hide the grouped rows.

So actually I want to control the +/- and 1/2 buttons indirectly.

Is this possible? Or should I do this by hiding rows instead of grouping them?

View 2 Replies View Related

Modify Code So It Doesn't Run If Sheet Doesn't Exist

Oct 24, 2011

Code below. I need it to NOT run if the sheet week2 doesn't exist. Currently it gives a runtime error '9' out of range. This is due tot he sheet not being present because sometimes it is not generated.

Code:

Sub RemoveColWeek2sheet()
Dim ColNo As Integer
Dim rng As Range
Set rng = ThisWorkbook.Sheets("Week2").UsedRange

[Code] .........

View 6 Replies View Related

Play DOS Games

Feb 25, 2009

is it possible to play dos games through excel? i want to somehow play my old championship manager games in excel whist at work (i don't actually want to work!!)

View 4 Replies View Related

Play WAV Files According To Criteria

Mar 26, 2014

How do I get my spreadsheet to play wav files I have saved according to certain criteria?

i.e. if certain value is entered into the cell, or on opening of the spreadsheet

I have message boxes appearing for the values in certain cells, however, don't know how I would add in the playing of a wav file to enhance this.

View 3 Replies View Related

Plotting Question - Play Y1 And Y2 Against X

Oct 4, 2007

I have the following data in excel (just an example):

X | Y1 | Y2
-3 | 9 | 1
-2 | 4 |
-1 | 1 | 1.5
0 | 0 |
1 | 1 | 1.5
2 | 4 |
3 | 9 | 1

I want to play Y1 and Y2 against X. Y2 does not appear on the chart because it's not continuous. I would like to plot Y1 (as a continuous graph) and a Y2 as dots (or scattered as excel lables it).

View 4 Replies View Related

Excel 2007 :: Macro To Play Different WAV Files Depending On Value Of Certain Cells

Feb 19, 2014

I have built a darts scoreboard on Excel 2007, to track scores but also record statistics such as 3 dart average and -checkout success. As I don't know how to write macro's I've created it using formulae only - it's not fancy but does the job!

I have a number of .WAV files that call out the main scores - 60, 100, 140 and 180 and I'd like the scoreboard to play the relevant file when someone scores that amount. I've trawled through lots of forums but have been able to find one that does exactly what I need it to, and I don't know how to adjust the ones I've found.

This is how the scoreboard works:

There are 25 different sheets, one for each leg of the match that could be played. The sheets are named Leg1, Leg2, Leg3 etc.On each sheet, Player 1's scores are entered in cells J15 to J47, and Player 2's scores are entered into cells O15 to O47Once Player 1 or Player 2 wins the leg, I move on to the next sheet to play the next leg. All the scores entered remain in each sheet until the match has ended

This is what I need the macro to do:

When a score of anything other than 60, 100, 140 or 180 is entered, do nothingWhen a score of 60, 100, 140 or 180 is entered, play the relevant .WAV fileIf, for example, Player 1 scores 60 the '60' .WAV file plays. 60 will be left in J15, then Player 2 may score 100, which will be entered into O15 and should trigger the '100' .WAV file.Note that either Player 1 or Player 2 can start the leg, so the order scores are entered between column J and column O can differ.

View 6 Replies View Related

Combination- List Of 10 Of My Favorite/lucky Numbers That I Want To Play In The Lottery

Aug 25, 2007

I have a list of 10 of my favorite/lucky numbers that I want to play in the lottery. The lottery picks 5 numbers total. I need a way to show me all the possible combinations of my 10 numbers picked in a 5 number draw (hope that makes sense). There are no repeat combinations- for example- I DO NOT WANT 1-2-3-4-5 and 5-4-3-2-1 to come up as separate combinations- so each of my favorite #s needs to be used only once in each combination, and each set used once.

I have searched this board for 2 hours now- read tons of other posts, but not finding a real solution. The output will be a list of all the possible combinations (no repeats, and no permutations) using my 10 favorite numbers. Another example-
1-2-3-4-5
1-2-3-4-6
1-2-3-4-7
1-2-3-4-8
1-2-3-4-9
1-2-3-5-6
1-2-3-5-7
and so on.

How do I create this? I realize the resulting table will be quite a large number of combinations- but we're going to have fun with it and pick a few at random.

View 9 Replies View Related

Sound Clips

Apr 6, 2007

I'm trying to write some VB code that will call up a sound file each time I give a new cell focus.

Example:

Cell A1 holds value "Hello"

I'm trying to write code that calls a sound clip I've recorded that says "Hello" when I select A1

Any suggestions?

View 7 Replies View Related

Using VBA To Turn Off Sound

Feb 26, 2008

How can I silence the annoying beep heard whenever a msgbox pops up or an error box appears?

View 9 Replies View Related

Playing Sound??

Oct 20, 2004

is there anyway of playing a sound once a user opens my excel file???

View 3 Replies View Related

VBA Sound Wav Alterations

Aug 24, 2006

I have made a standard Demo Workbook for testing Wav file VBA in this case.

It shows the problem code and a series of counters.

When the RED macro button is pressed, it should show the error code. and below a brief explanation.

I don't think it is an actual error as such, but I ask for an alteration. Once the code is solved, the GREEN button should work. If the demo book is downloaded it will explain better.

View 7 Replies View Related

Turning Off The Clipboard Sound

Dec 12, 2007

I recently installed Office 2002 onto a new computer and found that whenever I drag-and-drop any amount of data from one cell to another, a loud obnoxious noise plays when I release the drag-and-drop data.

I was using the same version of Office on my old computer and did not have this problem.

I'm guessing it's a clipboard issue, since when I open the Excel clipboard (where I currently have all options as unchecked) and copy something so it is captured there, the same noise plays.

I already have turned off Windows sounds via the Control Panel and have no clue how to turn off this sound.

View 12 Replies View Related

How To Get Sound Toggle Button

Apr 7, 2014

Is there a way to get a sound toggle button on excel?

What I need is a button to turn the sound alerts on and off on my spreadsheet. Ideally I'd like a button that either changed an image to the speaker image when on and the speaker image with line through it when off. Is that possible?

If not, is it possible to have a button that just says: "Sound:ON" or "Sound:OFF"?

I guess it could be done with tick boxes, or drop down options.

View 4 Replies View Related

Beep Sound When Condition Met?

Feb 26, 2014

The macro below is adding the SUM cell. Is it possible to make a beep sound when SUM cell value will be the same as one on the left?

[Code] .....

View 8 Replies View Related

Playing A Sound On Cell Value

Dec 20, 2008

I have an automated sort descend happening all day. The top several cells are coloured green and if a cell jumps to the top from below the green cells, I would love a warning sound. Is is possible to activate a sound if a cell changes from a colour to a non colour. Preferably if any of the cells within a range of say F2: F6 changes from green to a non colour.

If it is not possible to have a change of colour to activate the macro, I could get around it by - if any cells in a range of H2:H5 >than 1 it plays a sound.

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved