Can Excel Give Audible Alerts??

[ADE2]

Hi

Is it possible using Excel 2002 to get it to give audible alerts whe
an event takes place.

I use Excel for Currency trading,if cell A1 was greater than the valu
in cell A2,i would like to generate a sound alert and also to send a
email alert.

Are either of these possible

Many thanks

Ad

 

[DNF Karran]

I can help with the e-mail- though be aware the later versions of offic
have security settings that make this more difficult (post 2000)

With regards to the sound, the following should work- uses API:

Declare Function sndPlaySound32 Lib "winmm.dll" Alias _
"sndPlaySoundA" (ByVal lpszSoundName As String, _
ByVal uFlags As Long) As Long

Sub PlaySound(FileName As String)
sndPlaySound32 FileName, 0
End Sub

and can be called from the worksheet calculate event

Dunca