Just wondering if anyone knows how to stop a CANCELLED bet (bet that wasn't matched) appearing in the results worksheet. Therefore the only Bet results that would appear would be RESULT_WON, RESULT_LOST, RESULT_WAITING?
I'm assuming this might be a VB thing...
CANCELLED bet
Moderator: 2020vision
2 posts
• Page 1 of 1
by SW » Wed Jun 10, 2009 11:20 am
Think I've sussed this out. Within the worksheet code I wrote:
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'
' Delete Cancelled Bet
'
'
'
If Range("F2") = "CANCELLED" Then
Rows("2:2").Select
Selection.Delete Shift:=xlUp
End If
End Sub
Private Sub Worksheet_SelectionChange(ByVal Target As Range)
'
' Delete Cancelled Bet
'
'
'
If Range("F2") = "CANCELLED" Then
Rows("2:2").Select
Selection.Delete Shift:=xlUp
End If
End Sub
- SW
- Posts: 10
- Joined: Mon May 18, 2009 2:05 am
2 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 29 guests