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


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=384220

Sound Alarm when time expires
 

How does time expire in a cell???

--

Vasant


"EMoe" wrote in message
...

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

Sound Alarm when time expires
 

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

Thoughts????????


--
EMoe
------------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...o&userid=23183
View this thread: http://www.excelforum.com/showthread...hreadid=384220

Sound Alarm when time expires
 

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

Sound Alarm when time expires
 

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" wrote in message
...

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

Sound Alarm when time expires
 

Hi EMoe,

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

---
Regards,
Norman



"EMoe" wrote in message
...

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

Sound Alarm when time expires
 

Thanks Norman,

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

Regards,
EMo

--
EMo
-----------------------------------------------------------------------
EMoe's Profile: http://www.excelforum.com/member.php...fo&userid=2318
View this thread: http://www.excelforum.com/showthread.php?threadid=38422