+ Reply to Thread
Results 1 to 12 of 12

Alert - When 3 conditions are met on the same row

Hybrid View

  1. #1
    Forum Expert DGagnon's Avatar
    Join Date
    02-23-2012
    Location
    Ontario, Canada
    MS-Off Ver
    Excel 2003, 2007
    Posts
    1,645

    Re: Alert - When 3 conditions are met on the same row

    could you supply a test workbook? and the msgbox was my falut, this shoudl fix that

    Private Sub Worksheet_Change(ByVal Target As Range)
    Dim Flaged As Boolean
    Dim i As Integer
    Flaged = False
    
    For i = 2 To Range("C1048576").End(xlUp).Row
        If Range("C" & i).Value = "2) Replacement Only" And _
            Range("B" & i).Value < Date - 10 And _
            Range("H" & i).Value = 0 Then
            
            Range("H" & i).Interior.ColorIndex = 6
            Flaged = True
        End If
    Next
    
    If Flaged = True Then MsgBox ("A Replacement Only Order has not delivered yet.")
    
    End Sub
    Last edited by DGagnon; 04-16-2012 at 04:42 PM. Reason: code edit
    If you liked my solution, please click on the Star -- to add to my reputation

    If your issue as been resolved, please clearly state so and mark the thread as [SOLVED] using the thread tools just above the first post.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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