Play sound dependent upon value of two cells

[MagicMan]

Hi Folks.

I have this macro that will play a sound (wav file) when the value of cell M18 changes to 15

What I'd like to do is have it check two cells and if the values match then play a wav file

Here's the current code:

Please Login or Register  to view this content.

How can I edit this macro to check two cells (M18 and J13) and play a sound dependent upon the value of those two cells. I can't just use cell J13 as the cell in M18 is a control cell linked to a countdown clock. When it reaches 00:00:30 it changes value and then changes back when it reaches 00:00:29.

If the value of M18 is 15 and the value of J13 = "25/50" (it's a value and not a calculation) it will play one sound (countdownwav.wav). But,

If the value of M18 is 15 and the value of J13 = "50/100" it will play a different sound (for the sake of clarity, let's call it sound2.wav).

If the value of M18 is 15 and the value of J13 = "100/200" it will play sound3.wav

Appreciate your help guys ;-)

Terry

[JOHN H. DAVIS]

Maybe:

Please Login or Register  to view this content.