Playing .WAV file based on cell value change

[tangmere.milli]

Hi all,

I am desperate for help with this after trawling every website I can think of.

I have a spreadsheet with a database query attached (refreshing every 60 seconds) showing a stock summary by product.

I need the spreadsheet to play a .WAV file when values change. i.e.;

If cell A1 <6, play sound1.wav
If cell A2 <6, play sound1.wav
If cell A3 <6, play sound2.wav
If cell A4 <6, play sound2.wav

This may need to be repeated several times based on certain criteria. I have a total of about 30 cells which I need to be looked at individually (not a sum of) and to play the relevant sound.

I have seen different people try to tackle this in different ways. The ideal way would be creating alarms in VBA and triggering them using a formula, but I cannot get these to work in Excel 2010 or 2013.

Any help would be greatly appreciated!

TM

[Marc L]

Hi,

did you try with Worksheet_Change event ?

[tangmere.milli]

Hi Marc,

When it comes to VBA, I am very much a novice!

I have tried 2 different ways of doing this;

Please Login or Register  to view this content.

This seems to work for just cell A1, but I have no idea how to repeat it to play different sounds for different cells. I enter this code and if I enter the number 6 into A1, the sound plays. If I then go back to view code and then come back out of the code, this sound then seems to play if I enter <7 into ANY cell (very strange).

The other way I have tried is this;

Please Login or Register  to view this content.

And then use formula =IF(A1<7,SoundMe(),"") to trigger it, but this just brings back #NAME?. I don't think this works on later versions of Excel.

Can anyone see if I am making an obvious mistake?

Many thanks,

TM.

[Marc L]

According to forum rules, you must use code tags if you don't want to see your post locked !

Your obvious mistake is not to respect TBTO rule : you check only A1 cell but not changed ones in Target ‼
So it can't be very strange at all, it's only pure logic ! When logic fails, code can't work …

Example to check any change in cell A1 to A5 :

Please Login or Register  to view this content.

Enjoy it and don't hesitate to click on bottom left Add Reputation !

___________________________________________________________________________________
We are all very ignorant, what happens is that not all ignore the same things … (Albert Einstein)

[tangmere.milli]

Thanks for the tip Marc, I have now added code tags!

Many thanks for your help with this as well, code works perfectly for what I need!

[tangmere.milli]

Hi Marc,

I do have a slight issue with the spreadsheet now.

If I type a quantity of <7 into cell A1 manually, the sound plays as expected.

If the cell in A1 changes automatically based on a query data refresh (formula entered in this cell), then the sound does not play.

Do I need to tweak this code slightly?

Thanks again in advance!

TM.

[Marc L]

If any event is launched, nothing to do …