Manual Trigger from Exel

[samhayer]

Hi Any one can you tell be how is the best way to trigger a bet manualy from a exel sheet, I want to link a sheet to a market and then watch it in play and if I see the odds and the race being run to my liking I just want to click a cell with odds for my selection to place a bet, Which is the best way to do this If I use a macro I would have to use a macro for each runner any advice please thanks

[Captain Sensible]

Stick a Button next to each runner and use VBA to determine the row the button is placed on, something like can be the macro for all buttons.

Code: Select all

Sub BettingButton()
   Dim b As Object, RowNumber As Integer
    Set b = ActiveSheet.Buttons(Application.Caller)
    With b.TopLeftCell
        RowNumber = .Row
    End With
   
       
    Range("Q" & RowNumber).Value = "LAY"
    Range("R" & RowNumber).Value = 5
    Range("S" & RowNumber).Value = 10
   
     
   
End Sub