Notification when odds reach certain level?

[Qii]

Hi. I'm wondering if it would be possible to create an excel sheet where i could load certain markets for it to monitor, and when a certain price is hit it would notify me.
I'm not looking for it to place any bets, just let me know when the odds have been reached (by playing a sound clip maybe?)
I new to using excel with gruss, so i would just like to know if it is possible. And if it is I would be grateful if someone could point me in the right direction.
Thanks in advance

[osknows]

Depends on what notification you require but should be relatively straight forward...


To monitor a change in a worksheet normally this is used in the SHEET object in VBA editor...

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)

   If Target.Columns.Count = 16 Then
    Application.EnableEvents = False
    'your code here

    Application.EnableEvents = True
   End If

End Sub


To check if say F5 (Current Back odds) is less than 10 and display a message. However, a message stops the code until 'OK' is clicked

Code: Select all

Private Sub Worksheet_Change(ByVal Target As Range)

   If Target.Columns.Count = 16 Then
    Application.EnableEvents = False
    with ThisWorkbook.Sheets(Target.Worksheet.Name)

    if .range("F5").value <10 then msgbox("Less than 10")
    End with

    Application.EnableEvents = True
   End If

End Sub


If you want to play say the Chord.wav file in C:\Windows\Media\

you could use

Code: Select all

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

Private Sub Worksheet_Change(ByVal Target As Range)

   If Target.Columns.Count = 16 Then
    Application.EnableEvents = False
    With ThisWorkbook.Sheets(Target.Worksheet.Name)

    If .Range("F5").Value < 10 Then sndPlaySound32 "C:\Windows\Media\Chord.wav", 0&
    End With

    Application.EnableEvents = True
   End If
End Sub


[Qii]

Brilliant thanks mate