Advertisement
Guest User

Untitled

a guest
Nov 22nd, 2014
126
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.30 KB | None | 0 0
  1. Sub Innings()
  2.  
  3. If Range("H43") = 20# Then
  4.  
  5. MsgBox "Innings Completed"
  6.  
  7. End If
  8.  
  9. End Sub
  10.  
  11. Private Sub Worksheet_Calculate()
  12. Call Innings
  13. End Sub
  14.  
  15. Private Sub Worksheet_Change(ByVal Target As Range)
  16. If Not Intersect(Target, Range("H43")) Is Nothing Then
  17. Call Innings
  18. End If
  19. End Sub
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement