I need som Help with this statement....
If cell ("C4:c11") is <50 then Msgbox "you Got" C4 " Left " & " You may Now Close Game By 2 or 3 Dart's to close game"
Ive try this Code
Private Sub Worksheet_Change(ByVal Target As Range)
If Intersect(Target, Range("C5:C11")) Is Nothing Then
If Range("C5") < 50 Then MsgBox "You Got " & Range("C5").Value & " You may Now Close Game By 2 or 3 Dart's to close game"
Else
If Range("C6") < 50 Then MsgBox "You Got " & Range("C6").Value & " You may Now Close Game By 2 or 3 Dart's to close game"
Else
If Range("C7") < 50 Then MsgBox "You Got " & Range("C7").Value & " You may Now Close Game By 2 or 3 Dart's to close game"
Else
If Range("C8") < 50 Then MsgBox "You Got " & Range("C8").Value & " You may Now Close Game By 2 or 3 Dart's to close game"
Else
If Range("C9") < 50 Then MsgBox "You Got " & Range("C9").Value & " You may Now Close Game By 2 or 3 Dart's to close game"
Else
If Range("C10") < 50 Then MsgBox "You Got " & Range("C10").Value & " You may Now Close Game By 2 or 3 Dart's to close game"
Else
If Range("C11") < 50 Then MsgBox "You Got " & Range("C11").Value & " You may Now Close Game By 2 or 3 Dart's to close game"
End If
End If
End Sub
Bookmarks