Results 1 to 25 of 25

Else Function

Threaded View

  1. #1
    Registered User
    Join Date
    10-08-2018
    Location
    Denmark
    MS-Off Ver
    2016
    Posts
    68

    Else Function

    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
    Last edited by jeffreybrown; 12-09-2018 at 09:38 AM. Reason: Fixed code tags!

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. COUNTUNIQUE Function in Google Sheets; Excel lacks a direct counterpart to this function?
    By PivotTablePSHomage in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 03-18-2018, 05:27 AM
  2. Replies: 3
    Last Post: 08-14-2017, 06:26 AM
  3. Calling function inside function. (aka nested function)
    By jakopak in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-02-2015, 05:58 AM
  4. VBA code for custom function that returns detail results of array function
    By onechipshot in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 10-10-2015, 06:30 PM
  5. Replies: 1
    Last Post: 06-10-2015, 12:56 PM
  6. Replies: 13
    Last Post: 04-08-2014, 05:46 AM
  7. Replies: 1
    Last Post: 03-21-2012, 11:22 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1