Sound Alarm when time expires

Hello,

How do I write a code that will play a sound, such as the Mozzart sound clip that comes with windows, or any other music or sound clip that is on the computer after a certain time has expired in a cell.

Thanks,
EMoe

How does time expire in a cell???

--

Vasant


"EMoe" <EMoe.1rmhib_1120442705.1867@excelforum-nospam.com> wrote in message
news:EMoe.1rmhib_1120442705.1867@excelforum-nospam.com...
>
> Hello,
>
> How do I write a code that will play a sound, such as the Mozzart sound
> clip that comes with windows, or any other music or sound clip that is
> on the computer after a certain time has expired in a cell.
>
> Thanks,
> EMoe
>
>
> --
> EMoe
> ------------------------------------------------------------------------
> EMoe's Profile:
> http://www.excelforum.com/member.php...o&userid=23183
> View this thread: http://www.excelforum.com/showthread...hreadid=384220
>

I probably need to add a VBA code that automaticaaly updates the sheet, which would update the time every so many minutes.

Thoughts????????

A little clearer!

I want to compare a time entered into, say cell B1 with the current time, via formula =now(), cell A1.

When the time in A1 is the same as, or past the time entered into cell B1, activate (play) music clip.

I want to use vba to auto update the sheet, say every 3 minutes to keep the time moving/updated.

Is this possible?

Thanks,
EMoe

Hi EMoe,

See Chip Pearson's OnTime page at:

http://www.cpearson.com/excel/ontime.htm

and see John Walkenbach's tip # 87 on playing sounds:

http://www.j-walk.com/ss/excel/tips/tip87.htm


---
Regards,
Norman



"EMoe" <EMoe.1rmhib_1120442705.1867@excelforum-nospam.com> wrote in message
news:EMoe.1rmhib_1120442705.1867@excelforum-nospam.com...
>
> Hello,
>
> How do I write a code that will play a sound, such as the Mozzart sound
> clip that comes with windows, or any other music or sound clip that is
> on the computer after a certain time has expired in a cell.
>
> Thanks,
> EMoe
>
>
> --
> EMoe
> ------------------------------------------------------------------------
> EMoe's Profile:
> http://www.excelforum.com/member.php...o&userid=23183
> View this thread: http://www.excelforum.com/showthread...hreadid=384220
>

Thanks Norman,

Looks like the right track; I'll view them both.

Regards,
EMoe

Hi EMoe,

See response to your first post, which seems even more apposite with your
added detail.

---
Regards,
Norman



"EMoe" <EMoe.1rmpuc_1120453503.9511@excelforum-nospam.com> wrote in message
news:EMoe.1rmpuc_1120453503.9511@excelforum-nospam.com...
>
> A little clearer!
>
> I want to compare a time entered into, say cell B1 with the current
> time, via formula =now(), cell A1.
>
> When the time in A1 is the same as, or past the time entered into cell
> B1, activate (play) music clip.
>
> I want to use vba to auto update the sheet, say every 3 minutes to keep
> the time moving/updated.
>
> Is this possible?
>
> Thanks,
> EMoe
>
>
> --
> EMoe
> ------------------------------------------------------------------------
> EMoe's Profile:
> http://www.excelforum.com/member.php...o&userid=23183
> View this thread: http://www.excelforum.com/showthread...hreadid=384220
>