Sound Alert as a cell value changes

I simply want to hear a sound when a cell value changes ("S80"). No matter what the value of it is, whenever this cell changes its value, I want it to alarm. I searched the web for many solutions, including http://j-walk.com/ss/excel/tips/tip87.htm, but most of them are giving examples of Beep or .wav alert in response to a particular value (> 1000) or a certain threshold.

All I need is to know while working on my spreadsheet whether that cell ("S80") changes or not by hearing the alarm. I have been looking at Beep function, and it seems to work fine, except that it always alarms with disregard to what the cell value is.


Any help is greatly appreciated as I have been researching this for days now!

Thanks,

Hi mrdog,

Try putting the following code in the 'Sheet1' module (or the module for whatever the Sheet Name you are using is):

Please Login or Register  to view this content.

Lewis

Yes. S80 contains a SUM formula.

satabp, I tried this method before, and I just did again now. I beeps every time I enter a number ANYWHERE in the worksheet. Not necessarily affecting the value of S80 (now S90).

I have a set of individual cells containing certain numbers in column S: S30, S34, S56, ..S89. The sum of these numbers are in S90. The numbers in the individual S cells change according to certain categories. Which in turn would change the sum on S90. The reason why I need to hear the beep is because if I were to enter a category that is not included within the sum of the individual cells, the sum will not be affected and wouldn't hear the beep, which tells me that I need to add a category.

S90 contains: "=SUM(S4,S6,S10,S13,S21,S40,S46,S50,S56,S61,S71,S76,S80,S67,S88,S54)"

I tried using most posts in this thread, but I keep getting an error message. I don't have a huge experience with excel, and I would greatly appreciate a simplified way of doing this.

Thank you all for the help

I'm not sure why but I'm still having the same issue!
I'm starting a new spreadsheet to see if the problem is related to sheet im working on. I have a feeling that it is since I am using a large numbers of formulas that are associated with S90.
I will let you know how it goes..

Originally Posted by satabp

Hi,

Copy the following code in one of the module..

Please Login or Register  to view this content.

Step 1. Just select the all your cells to be included in the formula.. (Multiple cell selection can be done by holding the "Ctrl" key in keyboard)

Step 2: Once you selected all the required cells, just go to Address/Formula Bar. Left side just type the name as "MyRange" and press enter
(or) Press ALT I + N + D, then click on button "New" on the dialog box. And give the name as "MyRange" then click ok.

Step 3: Go to S90 and enter the formula as "=add(MyRange)"

Now, try to change the values of the cells in the range you selected.

satabp: You may want to change your function to replace 'Integer' with 'Variant', since you do not know what type of data mrdog is using.

mrdog: If you're still having problems, post a sample workbook. It just needs the sheet with the cell in it, and the cell with the formula in it. The rest of the workbook can be blank if you want. That will make it easier for us to post a solution that you can try out.

Lewis

LJMetzger, I am attaching a file with a note inside. The sheet should give a good view of what I am trying to do. In this worksheet though the cell that we're looking at is F13 not S90, for example sake.
Thanks,

Originally Posted by LJMetzger

satabp: You may want to change your function to replace 'Integer' with 'Variant', since you do not know what type of data mrdog is using.

mrdog: If you're still having problems, post a sample workbook. It just needs the sheet with the cell in it, and the cell with the formula in it. The rest of the workbook can be blank if you want. That will make it easier for us to post a solution that you can try out.

Lewis

Satabp, your sheet works great, until I add a sumif equation. Please see attached.

Originally Posted by satabp

Hi,

I have added the same in the attached blank file... in sheet1

check this..

That makes sense. So even if the amount stays the same, it is still recalculating. Understood. I'm guessing there is no way around it?

Originally Posted by satabp

The "TGIF" data range is part of the Sumif formula, so when ever it changes, the Total formula will recalculate it...

Hence Beep will come..

mrdog,

Try the attached file which implements my code above in the sample file you posted.

Lewis

Thank you so much Lewis. This is exactly what I need. Problem Solved! Your time is much appreciated. Thumbs UP!

Originally Posted by LJMetzger

mrdog,

Try the attached file which implements my code above in the sample file you posted.

Lewis