Activate Macro when time is below that in a different cell

[MagicMan]

Hi Guys,

I have a macro (lifted from elsewhere) that will play a sound when a value below 10 is entered in the cell.

I'd like to adapt it so when the value is equal to or below that of the value in a different cell it plays a wav file.

The challenge is in cell Sheet2!K17 I have a time value 00:00:30 (displayed in mm:ss).

What I want to do is when the cell value in Sheet1!J17 (which is a countdown timer) is equal to or below the value in cell Sheet2!K17 it plays the wav.

Here's the code. What do I need to change to make that happen please.

Please Login or Register  to view this content.

[xlnitwit]

Hi,

Does J17 contain a formula or is it a literal value entered somehow?

[MagicMan]

It does contain a formula. But I've been thinking I could introduce a control cell

[xlnitwit]

Because it is a formula, you need the Calculate event rather than the Change event

Please Login or Register  to view this content.

but you must appreciate that this will play the sound each time the workbook recalculates if the value is less than K12. If you only wish it to play once, you would require some sort of control variable, or value stored in a cell, to signal that it has already run once.